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

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

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

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD