[µ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

papaya

¦^´_ 11# hcm19522
hcm¤j¤j:
=IF(COUNT(MATCH(IF(OFFSET(B$1,K$1,,,7)=OFFSET(B$1,I2,,,7),OFFSET(B$1,I2,,,7),"A"),IF(OFFSET(B$1,I$1,,,7)=OFFSET(B$1,J$1,,,7),OFFSET(B$1,I$1,,,7)),)),I2,"")
¥»¤½¦¡µª®×¥¿½T¡C·PÁ«ü¾É!
½Ð±Ð¤@¤U:
¤½¦¡¤¤ªº"A"¡A¥Nªí¤°»ò·N«ä?
ÁÂÁ±z!

hcm19522

¦^´_ 10# papaya


   { =IF(COUNT(MATCH(IF(OFFSET(B$1,K$1,,,7)=OFFSET(B$1,I2,,,7),OFFSET(B$1,I2,,,7),"A"),IF(OFFSET(B$1,I$1,,,7)=OFFSET(B$1,J$1,,,7),OFFSET(B$1,I$1,,,7)),)),I2,"")

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!

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:
¥þ³¡OK¤F!
·PÁ­@¤ß«ü¾É!
¯¬:
½Ñ¦~§Ö¼Ö!
¤ß·Q¨Æ¦¨^^

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

¦^´_ 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

papaya

¦^´_ 4# hcm19522

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

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,"")