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

¤ñ¹ïªº±ø¥ó¬O¡G­^¤å¤j¤p¼g­n¤@¼Ë¡A¤~¥i¥H¼ÐµùÈвŦXÈÐ

{=IF(OR(EXACT(A2,IF(A2=D$2:D$1999,D$2:D$1999))),"²Å¦X","")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD