[µo°Ý] «ü©w¥|­Ó¦C¦P®ÉÅã¥Ü¬Y1­Ó(§t)¥H¤W­Èªº"2003ª©"ªº¨ç¼Æ¤½¦¡¡C

papaya

¤U¸ü (153.39 KB)

2019-1-30 18:54

¤U¸ü (150.36 KB)

2019-1-30 18:54

½d¨ÒªþÀÉ:
4¦C¥æ¶°.rar (3.02 KB)

¤U¸ü¦¸¼Æ: 6

2019-1-30 18:55

hcm19522

https://blog.xuite.net/hcm19522/twblog/586673910

papaya

¦^´_ 2# hcm19522
hcm¤j¤j:
Sheet1 :¤G´Á¦ì¸m¬Û¦Pªº¼Æ¦r¦³¦P®É¦³¥X²{¥t¤G´Á ~OK¤F!
·PÁ«ü¾É!ÁÂÁÂ!

Sheet2 :¤G´Á¦ì¸m¬Û¦Pªº¼Æ¦r¦³¦P®É¦³¥X²{¥t¤G´Áªº¦PÄæ
¦n¹³º|±¼¤F^^"
½ÐÄ~Äò«ü¾É!ÁÂÁÂ!

hcm19522

=IF(SUMPRODUCT((OFFSET(B$1,J$1,,,7)=OFFSET(B$1,I$1,,,7))*(OFFSET(B$1,K$1,,,7)=OFFSET(B$1,I$1,,,7))*(OFFSET(B$1,I2,,,7)=OFFSET(B$1,I$1,,,7))),I2,"")

papaya

¦^´_ 4# hcm19522

hcm¤j¤j:
§¹¦¨¤F!ÁÂÁ±z!

papaya

¦^´_ 4# hcm19522

hcm¤j¤j:
¤£¦n·N«ä¡A·Q±NJ2ªº¤½¦¡²Å¦X±ø¥ó1ªºK$1©MI2Åã¥Üªº¬Û¦P¼Æ¦r¡C¶i¶¥¬°¦PÄæ~
¦ý§Ú¥HJ2¤½¦¡²K¤W*OR(OFFSET(B$1,K$1,,,7)=OFFSET(B$1,I2,,,7))¶K¤WK2¤U©Ô¡Aµª®×¤£¥¿½T^^"
½Ð°Ý:K2ªº¤½¦¡­n¦p¦ó½s¼g?
ÁÂÁ±z!

¤U¸ü (148.04 KB)

2019-2-2 07:13

½d¨ÒªþÀÉ :
«á2¦C¦PÄæ¥æ¶°.rar (2.98 KB)

¤U¸ü¦¸¼Æ: 3

2019-2-2 07:14

hcm19522

¦^´_ 6# papaya

=IF(SUMPRODUCT(COUNTIF(OFFSET(B$1,I$1,,,7),OFFSET(B$1,K$1,,,7))*COUNTIF(OFFSET(B$1,J$1,,,7),OFFSET(B$1,K$1,,,7))*(OFFSET(B$1,I2,,,7)=OFFSET(B$1,K$1,,,7))),I2,"")

papaya

¦^´_ 7# hcm19522


hcm¤j¤j:
¥þ³¡OK¤F!
·PÁ­@¤ß«ü¾É!
¯¬:
½Ñ¦~§Ö¼Ö!
¤ß·Q¨Æ¦¨^^

papaya

¦^´_ 7# hcm19522

hcm¤j¤j :
¥i¯à¬O¦]§Úªº»¡©ú¤£²M·¡¡A©Ò¥H¸ÑÃD¤½¦¡¦n¹³¦³»~®t^^"
­«·s»¡©ú¦p¤U:
²Ä1­Ó±ø¥ó~I$1©MJ$1¤G­Ó´Á¼Æªº¦PÄ楲¶·¦³1­Ó(§t)¥H¤Wªº¼Æ¦r¡C
²Ä2­Ó±ø¥ó~²Å¦X²Ä1­Ó±ø¥óªº¼Æ¦r¡A¥²¶·¦³1­Ó(§t)¥H¤W¦P®É¥X²{¦bK$1©MI2¤G­Ó´Á¼Æªº¦PÄæ¡C
§YI$1©MJ$1¦PÄ檺¬Û¦P¼Æ¦r¡A¦³¥X²{¦bK$1©MI2ªº¦PÄæ¡C

K2¤½¦¡·Ð½Ð¦A­×¥¿¡C
ÁÂÁ±z!

papaya

¦^´_ 7# hcm19522
hcm¤j¤j:
¦A¸É¥R»¡©ú:
4#¬OI$1,J$1,K$1,I2³£¦PÄæ¡F
²{¦bªº»Ý¨D¬O¥u­nI$1©MJ$1¦PÄæ¡F¥t¥~K$1©MI2­n¦PÄæ¡C
ÁÂÁ±z!