C2{=IFERROR(TRIM(MID(SUBSTITUTE(INDEX(A:A,SMALL(IF(LEN(A$2:A$5)-LEN(SUBSTITUTE(A$2:A$5,",",))+1>=COLUMN(A:I),ROW($2:$5)),ROW(A1))),",",REPT(" ",19)),RIGHT(SMALL(IF(LEN(A$2:A$5)-LEN(SUBSTITUTE(A$2:A$5,",",))+1>=COLUMN(A:I),{2;3;4;5}/1%+COLUMN(A:I)),ROW(A1)))*19-18,19)),"")
輔助F2 {=INDEX(A:A,SMALL(IF(LEN(A$2:A$5)-LEN(SUBSTITUTE(A$2:A$5,",",))+1>=COLUMN(A:I),ROW($2:$5),99),ROW(A1)))&""
G2=IF(F2="","",TRIM(MID(SUBSTITUTE(F2,",",REPT(" ",99)),COUNTIF(F$2:F2,F2)*99-98,99)))
留言
張貼留言