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

½Ð°Ý¦³Ãö¤ñ¹ï°ÝÃD(´«­Ó¤è¦¡¸ß°Ý)¥d¤F«Ü¦h¤Ñ ¤@ª½³B²z¤£¦n ÁÂÁÂ

½Ð°Ý¦³Ãö¤ñ¹ï°ÝÃD(´«­Ó¤è¦¡¸ß°Ý)¥d¤F«Ü¦h¤Ñ ¤@ª½³B²z¤£¦n ÁÂÁÂ

½Ð°Ý¦³Ãö¤ñ¹ï°ÝÃD(´«­Ó¤è¦¡¸ß°Ý)¥d¤F«Ü¦h¤Ñ ¤@ª½³B²z¤£¦n  ÁÂÁÂ
©Ò¥H§Ú´N¥u¥Î¥X°ÝÃDªº²Ó¸`¥h¸ß°Ý¤j®a¤F
ÁÂÁ¤j®a


¥ÎDÄæ¦ìªº¼Æ¦r(«D¤å¦r)
¨Ó´M§äAÄõ¤º®e
¦pªG¦³¥X²{¬Û¦P¼Æ¦r
´NÅã¥Ü¥X¨Ó
¦ýAÄæ¦ì«D¾ã¼Æ ¤]¥i¯à¼Æ¦r¤Î¤å¦r³£¦³
¨Ï¥Î¹LSEARCH,³£¦n¹³³£¤@ª½¥X°ÝÃD
¬ß½Ð¤j¤j«ü±Ð
°ÝÃD.rar (71.3 KB)
lo

=IFERROR(LOOKUP(1,0/FIND(D$2:D$6,A2),D$2:D$6),"")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522



    hcm19522 ¤j¤j±z¦n
±zµ¹ªº¤½¦¡¬O¥i¥H¨Ï¥Îªº
¦ý¬O§Úªº­ì©lÀÉ®×®M¥Î«áÁÙ¬O¦³¥X°ÝÃD
¥i§_¦³±zªº¨p¤UÁpµ¸¤è¦¡
§Ú±N­ì©lÀÉ®×µ¹±z¬Ý¤@¤U
ÁÂÁ±z
lo

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2017-3-27 22:20 ½s¿è

­Y¦³
1122
112
122
11
22

À³·|¦³»~§ì°ÝÃD!!

¸Õ¸Õ:
=IFERROR(VLOOKUP(-LOOKUP(,-MID(A2,MATCH(,0*MID(A2,ROW($1:$29),1),),ROW($1:$15))),D:D,1,),"")
°}¦C¤½¦¡

TOP

¦^´_ 2# hcm19522

hcm19522¤j¤j±z¦n
§Ú±N¸ê®Æªí­×§ï¦¨¤ñ¸û¨S¦³¾÷±KªºÀÉ®×

¥i§_½Ð±zÀ°§ÚÆ[¬Ý¤@¤U

¦]¬°Àx¦s®æ¸ê®Æ¤j³¡¤À³£¬O³sµ²¥~³¡Àɮתº

¥þ³¡¸ê®Æ¦p¤U
Comparison.rar (40.67 KB)


ÁÂÁÂ
lo

TOP

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


    ­ã´£³¡ªL ª©¥D¤j¤j

§Ú±N¸ê®Æªí­×§ï¦¨¤ñ¸û¨S¦³¾÷±KªºÀÉ®×

¥i§_½Ð±zÀ°§ÚÆ[¬Ý¤@¤U

¦]¬°Àx¦s®æ¸ê®Æ¤j³¡¤À³£¬O³sµ²¥~³¡Àɮתº

¥þ³¡¸ê®Æ¦p¤U
Comparison.rar (40.67 KB)


ÁÂÁÂ
lo

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD