F2:H6{=IFERROR(INDEX(TRIM(MID(SUBSTITUTE(SUBSTITUTE($B$2:$B$4,$E2,$A$2:$A$4),"、",REPT(" ",99)),{1,2,3,4}*99-98,99)),LEFT(SMALL(IF(ISNUMBER(FIND($E2,TRIM(MID(SUBSTITUTE($B$2:$B$4,"、",REPT(" ",99)),{1,2,3,4}*99-98,99)))),{1;2;3}/1%+{1,2,3,4}),COLUMN(A1))),RIGHT(SMALL(IF(ISNUMBER(FIND($E2,TRIM(MID(SUBSTITUTE($B$2:$B$4,"、",REPT(" ",99)),{1,2,3,4}*99-98,99)))),{1;2;3}/1%+{1,2,3,4}),COLUMN(A1)))),"")
B16:D18=$A2&TRIM(MID(SUBSTITUTE($B2,"、",REPT(" ",99)),COLUMN(A1)*99-98,99))
F16:H20=IFERROR(SUBSTITUTE(T(INDIRECT(TEXT(SMALL(IF(ISNUMBER(FIND($E16,$B$16:$D$18)),ROW($16:$18)/1%+{2,3,4}),COLUMN(A1)),"!R0C00"),)),$E16,),"")
留言
張貼留言