ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

¦^´_ 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,"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD