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

±a¥X²Å¦X¤@ªø¦ê¦r¦ê¸ê®Æ

±a¥X²Å¦X¤@ªø¦ê¦r¦ê¸ê®Æ

°ÝÃD¡G
BÄæ¨Dªºµª®×¬O¡G
AÄ椺¥u­n¦³©ME1©ME2¤º¥ô¦ó¤@­Ó¦r¦ê²Å¦X´N¦bBÄ椺¼Ð¥Ü
¨Ò¦p:
E1¸Ì¦³XSV©MXSW¡K¡A«hÀx¦s®æA8351©MÀx¦s®æA8352¦³²Å¦X³o¨â­Ó¦r¦ê¡AÀx¦s®æB8351Åã¥ÜXSV¡AÀx¦s®æB8352Åã¥ÜXSW


CÄæ¨Dªºµª®×¬O¡G
AÄ椺¥u­n²Å¦XÀx¦s®æE1ªº¥ô¦ó¤@­Ó¦r¦ê¡A´N¦bCÄ椺Åã¥ÜXSV
AÄ椺¥u­n²Å¦XÀx¦s®æE2ªº¥ô¦ó¤@­Ó¦r¦ê¡A´N¦bCÄ椺Åã¥ÜXT3
¨Ò¦p¡G
Àx¦s®æA8351©MÀx¦s®æA8352²Å¦XE1¤º¥ô¤@¦r¦ê¡A«hÀx¦s®æB8351Åã¥ÜXSV¡AÀx¦s®æB8352Åã¥ÜXSV

±a¥X²Å¦X¤@ªø¦ê¦r¦ê¸ê®Æ ªº½Æ¥».zip (53.1 KB)

joyce

B2:
=IF(COUNT(FIND(A2,E$1)),A2,"")

C2:
=IFERROR(LEFT(VLOOKUP("*"&A2&"*",E$1:E$2,1,),3),"")

TOP

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


    ÁÂÁ¦^ÂÐ
¦ýBÄæ¦ì,¥u¦³±a¥XXSV¡AXSW¡AXSX¡A¨ä¥LªºXSY¡AXSZ¡AXT0¡AXT1¡AXUX¡AXV0¡AXV1¡AXV2¤]­n±a¥X¨Ó¡AÁÙ¦³¤£­n±a¥XS¡AT¡AU¡AV¡AX

CÄ椺±a¥XªºXSV¡A¹ïÀ³ªº¢ÏÄ椣­n¦³S¡AT¡AU¡AV¡AX
joyce

TOP

¦^´_ 3# leiru

=IF(COUNT(FIND("+"&A2&"+","+"&MID(E$1,5,199)&"+")),A2,"")

=iferror(LEFT(LOOKUP(1,-FIND("+"&A2&"+","+"&MID(E$1:E$2,5,199)&"+"),E:E),3),"")

TOP

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


    ÁÂÁÂ

¤£¦n·N«ä¡A½Ð°ÝBÄæ©MCÄæ¤]­n±a¥XXSV¡AXT3¡A¦p¦ó§ï¤½¦¡
joyce

TOP

¦^´_ 5# leiru


«ç»ò±a, ¼ÒÀÀµ²ªG¬Ý¬Ý~~

TOP

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


    ¤]­n±a¥Xªº¸ê®Æ¦p¶À¦â°Ï¶ô

¯u¤ß·PÁ±z

±a¥X²Å¦X¤@ªø¦ê¦r¦ê¸ê®Æ.zip (98.07 KB)

joyce

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2020-5-23 10:06 ½s¿è

¦^´_ 7# leiru


B2/°}¦C:
=IF(COUNT(FIND("+"&A2&"+","+"&SUBSTITUTE(E$1:E$2,"=","+")&"+")),A2,"")

C2/¤@¯ë:
=IFERROR(LEFT(LOOKUP(1,-FIND("+"&A2&"+","+"&SUBSTITUTE(E$1:E$2,"=","+")&"+"),E:E),3),"")

============================================
­Y±N¦r¦ê§ï¦¨:
XSV+/+XSW+XSX+XSY+XSZ+XT0+XT1+XUX+XV0+XV1+XV2
XT3+/+XT4+XT5+XT6+XT7+XT8+XT9+XUY+XV3+XV4+XV5

=IF(COUNT(FIND("+"&A2&"+","+"&E$1:E$2&"+")),A2,"")
=IFERROR(LEFT(LOOKUP(1,-FIND("+"&A2&"+","+"&E$1:E$2&"+"),F:F),3),"")


============================================

TOP

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


    ÁÂÁÂ
½Ð°Ý­Yªí®æ¼Ò¦¡­Ë¹L¨Ó¡A¸Ó¦p¦ó³]©w¤½¦¡¡A¦pªþÀÉ
°ÝÃD¡G
AÄ椺ªº¦r¦ê¦³²Å¦XDÄ椺ªº¦r¦ê¡A«hBÄ檺µª®×Åã¥Ü¥X¨Ó¡A¨D¢ÐÄæ

¬¡­¶Ã¯2.zip (7.87 KB)

joyce

TOP

¦^´_ 9# leiru


°ªª©¥»ªº¦³¦X¨Ö¦r¦ê¨ç¼Æ, §Ú¨S¦³!
§Cª©¥»­n¥ÎVBA

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD