EXCEL多单元格多内容拆分单行?答:向右填充至班级列,然后向下填充。考试项目列输入公式:=TRIM(MID(SUBSTITUTE(INDEX(C:C,SMALL(IF(LEN(C$2:C$999)-LEN(SUBSTITUTE(C$2:C$999,";",))+1>=COLUMN($A:$Z),ROW($2:$999)),ROW(A1))),";",REPT(" ",99)),(COUNTIFS($F$2:$F2,$F2,$G$2:$G2,$G2))*99-98...
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))...