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

¨âÄæ¤ñ¹ï,§ä¥X¤£¦s¦b&­«ÂÐ

¨âÄæ¤ñ¹ï,§ä¥X¤£¦s¦b&­«ÂÐ

¥»©«³Ì«á¥Ñ Qin ©ó 2017-10-13 10:21 ½s¿è

Book1.rar (5.64 KB)

¥HAÄæ¬°¼Ð·Ç,§ä¥X¤£¦s¦bªº&²Ä¤G­Ó­«ÂÐ

¦p¦ó·íBÄæ¶ñ¤J»PAÄæ¦³ªº¬Û¦P²Ä¤G­Óµª®×®É,CÄæÅã¥Ü¬°­«ÂЩΤ£¦s¦b
   

Test.png

C1¶ñ¤J(¨ä¾l¤U©Ô)
  1. =IF(B1="","",IF((COUNTIF(A:A,B1))<1,"¤£¦s¦b",IF((COUNTIF($B$1:B1,B1))>1,"­«½Æ","")))
½Æ»s¥N½X

TOP

¦^´_ 2# naruto018

¿ð¨Óªº·PÁÂ!

¸Ñ¤F§Ú·í®Éªº¤Q¸U¤õ«æ!!

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD