拆帳目類型明細 (13991)

F2{=INDEX(A:A,SMALL(IF(COLUMN(A:Z)<=LEN(B$2:B$6)-LEN(SUBSTITUTE(B$2:B$6,"+",))+1,ROW($2:$6),99),ROW(A1)))&""

G2=IF(F2="","",TRIM(MID(SUBSTITUTE(VLOOKUP(F2,A:B,2,),"+",REPT(" ",99)),COUNTIF(F$2:F2,F2)*99-98,99)))