D2:D5=SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(B2,","," "),A2,))," ",",")
C9:F12{=IFERROR(IF($A$8=A$8,"",",")&INDEX(TRIM(MID(SUBSTITUTE($B9,",",REPT(" ",99)),ROW($1:$9)*99-98,99)),SMALL(IF(ISERR(FIND(TRIM(MID(SUBSTITUTE($B9,",",REPT(" ",99)),ROW($1:$9)*99-98,99)),$A9)),ROW($1:$9)),COLUMN(A1)))&D9,"")
留言
張貼留言