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

¦p¦ó¨Ì¿é¤J¤º®e§PÂ_©ÒÄݪºÃþ§O

Hello, ­ã¤j

½Ð±Ð, §A©Ò¦^ÂЪº³o­Ó¤½¦¡OOKUP(1,-FIND(A$2:A$7,D2),B$2:B$7).

1. Find ¨ç¼Æ«e, ¥[¤W"-"ªº¥Î·N¬°¦ó? ¯à§_¸ÑÄÀ¤@¤U?
2. ¥tLookup ¨ç¼Æ, §ä¤£¨ì¨ä¤ñ¹ï­È(¦p33 or ªÅ®æ)®É, ¥i¦³¤èªk§P§O¥X¨Ó?

Thanks ~
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

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

Hello, ­ã¤j

¤F¸Ñ! ÁÂÁ§Aªº¸Ñ»¡....
Thanks ~
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD