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

©î¸Ñ¥X¦a§}ªº¦U¶µ¸ê°T¡C

©î¸Ñ¥X¦a§}ªº¦U¶µ¸ê°T¡C

¦U¦ì¤j¤j¦n¡A§Ú·Q¼g¤@­Ó¨ç¦¡¡A¥iÅý¨Ï¥ÎªÌ¦bAÄæ¿é¤J¦a§}¤§«á¡A¦Û°Ê©î¸Ñ¥X¦a§}ªº¦U¶µ¸ê°T¡A¦p¥H¤U½d¨Ò(²Ä4¦C¬O¥¿½Tµ²ªG)¡A¦ý§Úµo²{§Ú¦bD6Àx¦s®æªº¼gªk¡A¨S¦³¿ìªkº¡¨¬·í¬Y¨Ç¦a§}¸ê°T¤£¦s¦b®Éªºª¬ªp¡A¨Ò¦p½d¨Òªº¦a§}µL"§ø"¡A´N·|¼vÅT¨ì§ø»P¨½ªº¸ê°T¡A½Ð°ÝÀ³¸Ó¦p¦ó­×§ï¨ç¦¡©O¡H ¦a§}¤À©î.rar (8.93 KB)

B4
=IF(COUNTIF($A4,"*"&B$1&"*"),IF(B$1="¤§",MID($A4,FIND(B$1,$A4)+1,99),MID(LEFT($A4,FIND(B$1,$A4)-1),1-LOOKUP(1,IF({1,0},0,LOOKUP(,-FIND($A$1:A$1,$A4)))),99)),"")
¥k©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁÂ!¨S·Q¨ì©~µM¯uªº°µ±o¥X¨Ó~¥i§_½Ð±Ð¤j¤j"1-LOOKUP(1,IF({1,0},0,LOOKUP(,-FIND($A$1:B$1,$A5))))"µ{¦¡½X©Ò¥Nªíªº·N«ä¡H¤×¨ä¬O{1,0}ªº·N¸q¡H

TOP

>>"1-LOOKUP(1,IF({1,0},0,LOOKUP(,-FIND($A$1:B$1,$A5))))"µ{¦¡½X©Ò¥Nªíªº·N«ä¡H¤×¨ä¬O{1,0}ªº·N¸q¡H

¨Ò¦p²Ä«ü¨S¦³"°Ï"¡A©ÒFIND­n§ä"°Ï"ªº¦ì¸m¨S¦³§ä¨ì®É·|²£¥Í¿ù»~¡A
¥~³òªºLOOKUPªº¥\¯à´N¬O¸Ì­±ªºLOOKUP²£¥Í¿ù»~®É¡A±N¿ù»~­È§ï¬° 0
IF({1,0} ¬Û·í¬° IF({TRUE,FALSE} ¡A±N0»P LOOKUP(,-FIND($A$1:B$1,$A5))¦X¨Ö¬° {0,LOOKUP¬d¸ß­È}
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD