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

[µo°Ý] ¦b¨S¦³±Æ§Çªº±¡§Î¤U,¬Û¦P²£«~½s¸¹¡A¯d¤U³Ì«á¤@­Ó´N¦n

§Úµo²{¦pªG¥Î¨ç¼Æ¼gªº¸Ü,§Úªº¸ê®Æ¶W¹L1¸Uµ§´N­nºâ¶W¤[ªº,Àɮפ]Åܱo«Ü¤j¤£¦n¶}±Ò
¤K¶³

TOP

¤j¤j§A¦n.. §ÚÁÙ¦³¥t¤@ÃøÃD.. ´N¬O¥Î§Aªº¤½¦¡.. MATCH¬O¦³NA..½Ð°Ý¥i¥H¦p¦ó¸Ñ¨M©O?

countif match na.rar (11.07 KB)

¦^´_  PJChen

    ¸Õ¬Ý¬Ý
    E5=IF(COUNTIF(B:B,B5)=1,B5,IF(ROW()=MATCH(B5,B:B,2),B5,""))
    ¤½ ...
owen06 µoªí©ó 2014-11-28 12:29

TOP

=IF(ISNA(MATCH(B5,B6:B3000,)),B5,)&""
­ã´£³¡ªL µoªí©ó 2018-3-30 17:10



§Ú¸ÕµÛ¥Î§A±Ðªº¤½¦¡..
³£¬O¤£¦æ..
><.

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD