ªð¦^¦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 : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD