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

[µo°Ý] ¦WºÙ¤@¼Ë¸ê®Æ«o·|§ì¤£¨ì¡H(¤w¸Ñµª¡A·PÁÂHsieh«e½ú)

[µo°Ý] ¦WºÙ¤@¼Ë¸ê®Æ«o·|§ì¤£¨ì¡H(¤w¸Ñµª¡A·PÁÂHsieh«e½ú)

¥»©«³Ì«á¥Ñ solitary0713 ©ó 2011-10-6 12:15 ½s¿è

«~¶µ¥þ³£¬O¥Î½Æ»s¶K¹L¨Óªº
¦ý¥u­n«á­±±a¦³¼Æ¦r¸ò­^¤å¦r³£·|§ì¤£¨ì
½Ð°Ý¦³¤°»ò¸Ñ¨M¿ìªk¶Ü¡H

½s¸¹§ì¨ú.rar (3.42 KB)

¦^´_ 1# solitary0713
ªi®ö¸¹¦b·d©Ç
=INDEX(A:B,MATCH(SUBSTITUTE($D2,"~","~~"),B:B,0),1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh
«z
«e½ú¯u¬O¤Ó¼F®`¤F
¯à§_¦b¬°§Ú¸ÑÄÀ¤@¤U¼W¥[ªº¨º¬q(SUBSTITUTE($D2,"~","~~")
¬Ý¤Fexcel¦Û¤vªº»¡©úÁÙ¬O¤£¤F¸Ñ

TOP

¦^´_ 3# solitary0713

MATCH©ÎVLOOKUPµ¥·j´M¨ç¼Æ
­n·j´M¸U¥Î¦r²Åªº½T¹ê¦r¤¸¡A¦p¬P¸¹*©Î?µ¥
¥i¦b¸U¥Î¦r²Å«e¥[¤Wªiª¬²Å¸¹~
¦]¬°§Aªº·j´M­È¥]§t¤Fªiª¬²Å¸¹¦r¤¸
©Ò¥H¨Ï¥ÎSUBSTITUTE¨ç¼Æ
±N¦r¦ê¤¤³æ¤@ªiª¬²Å¸¹~¸m´«¦¨~~¤~·|§ä¨ì~³o­Ó¦r¤¸
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD