B2:D3=IFERROR(-LOOKUP(,-MID(TRIM(MID(SUBSTITUTE(MID($A2,FIND(B$1,$A2),99),"Value",REPT(" ",99)),99,99)),4,ROW($1:$9))),"")
另解=IFERROR(-LOOKUP(,-MID($A2,FIND("V",$A2,FIND(B$1,$A2))+8,ROW($1:$9))),"")
另解=IFERROR(-LOOKUP(,-LEFT(MID($A2,FIND(B$1,$A2)+FIND("Value",MID($A2,FIND(B$1,$A2),99))+7,99),ROW($1:$9))),"")
留言
張貼留言