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

[µo°Ý] ¼Æ¦r¼Ò½k¬d§ä

[µo°Ý] ¼Æ¦r¼Ò½k¬d§ä

½Ð°Ý¦U¦ì¤j¤j
¼Æ¦r¼Ò½k¬d¸ß,¦pªþ¥ó
¨Ï¥ÎLOOKUP(,-FIND(C2,$A$2:$A$100),$B$2:$B$100)¬d¸ß¼Æ¦r210¥i¦^¶Ç"10" (D2Àx¦s®æ)

¦ý¬O¦pªG¬d¸ß¼Æ¦r¤¶©ó¸ê®Æ¼Æ¦r¤§¶¡,´NµLªk¬d§ä(D4Àx¦s®æ)
¦pªG¿é¤J¼Æ¦r211«o¦^¶Ç¸ê®Æ¦C19.211,  ±o¨ì64ªº¼Æ¾Ú(D3Àx¦s®æ)
¥H¤W³o¨â­Ó°ÝÃD½Ð±Ð¬O§_¦³¸Ñ
ÁÂÁÂ

¼Æ¦r¼Ò½k·j´M.zip (10.39 KB)

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD