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

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

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

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

¤ñ¹ï­^¤å¤j¤p¼g¤@­P¡A¤~¼Ðµù¡G²Å¦X.zip (156.71 KB)

joyce

B2=IF(EXACT(A3305,IFERROR(OFFSET(D$1,MATCH(A3305,D:D,0)-1,0,1,1),"")),"²Å¦X","")

TOP

=IF(EXACT(A2,IFERROR(VLOOKUP(A2,D:D,1,0),"?")),"²Å¦X","")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¾Ç²ß·sª¾ÃѤF¡A·P®¦Åo!
Just do it.

TOP

{=IF(OR(EXACT(A2,IF(A2=D$2:D$1999,D$2:D$1999))),"²Å¦X","")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

·PÁÂfengetianxia¤ÎML089¤Îhcm19522¤T¦ì¤j®v¼ö¤ß¸Ñµª
joyce

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD