Excel如何核查一个单元格内(文字伴有逗号)是否有重复的项目?答:如图:A2=TEXTJOIN(",",,IF(MATCH(TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",99)),COLUMN(A:Z)*99-98,99)),TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",99)),COLUMN(A:Z)*99-98,99)),)=COLUMN(A:Z),"",TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",99)),COLUMN(A:Z)*99-98,99))...