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

[µo°Ý] ¨ú¦P¤@­û¤u³Ì«áÁ~ª÷

[µo°Ý] ¨ú¦P¤@­û¤u³Ì«áÁ~ª÷

½Ð°Ý¨C¤@­û¤u¦³¦h©ó¤@±øªº¥[Á~¬ö¿ý,¦p¦ó¥Î¨ç¼Æ¨ú±o¨ä³Ì«á¤@±ø¥Í®Äªº°O¿ý?

¨ú¨C­û¤u³Ì«á¤@­Ó°O¿ý.zip (7.41 KB)

F2=LOOKUP(E2,A:A,B:B)

TOP

­û¤u½s¸¹¤£±Æ§Ç¡A³Ì·s¸ê®Æ¦b³Ì©³¤U¡A¢Ô¢±¡G
=IF(COUNTIF($A:$A,$E2),LOOKUP(1,0/($A$2:$A$13=$E2),B$2:B$13),"")

TOP

¦^´_ 2# ANGELA

·PÁ¸ѵª. °ÝÃD¤w¸Ñ¨M.

TOP

¦^´_ 3# ­ã´£³¡ªL

·PÁ¸ѵª. °ÝÃD¤w¸Ñ¨M. ³o¤èªk¯à¦b¤£±Æ§Ç¤U¨ú±o¥¿½T¸ê®Æ, ¦hÁ¤j¤j.

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD