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

ºI¨ú¯S©w¦r¦ê

ºI¨ú¯S©w¦r¦ê

°ÝÃD¡G
BÄ椺­nºI¨úAÄ椺ªº¬ì¥Ø(©Ò«üªº¬ì¥Ø¬O«ü²Å¦XEÄæ)¡ACÄæ¬O¦©°£BÄæ¥H¥~ªº¦r¦ê
½Ð°Ý¦p¦ó³]©w

¬¡­¶Ã¯4.zip (7.43 KB)

joyce

¦^´_ 1# leiru

¬¡­¶Ã¯4-A.rar (9.31 KB)
    B2¿é¤J
=IFERROR(INDEX($A$2:$A$71,MATCH($E2,IFERROR(IF(CODE(MID($A$2:$A$71,10,1))>70,LEFT($A$2:$A$71,9),LEFT($A$2:$A$71,10)),LEFT($A$2:$A$71,8)),0),0),"")
°}¦C
C2¿é¤J
¸ò¹q·xÄl¤j¤@¼Ëªº¤½¦¡
©Î
=IFERROR(MID(B2,LEN(E2)+1,LEN(B2)-LEN(E2)),"")

TOP

¦^´_ 2# ¹q·xÄl


    ÁÂÁ±zªº¦^ÂÐ
joyce

TOP

¥»©«³Ì«á¥Ñ ¹q·xÄl ©ó 2015-2-3 16:26 ½s¿è

B2
  1. =INDEX(E:E,LARGE(IF(ISERROR(FIND($E$2:$E$91,A2)),"",ROW($E$2:$E$91)),1))°}¦C
½Æ»s¥N½X
C2
  1. =SUBSTITUTE(A2,B2,"")
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD