EXCEL表格中同一单元格内重复考勤数据处理问题?答:在E2单元格输入公式=IFERROR(INDEX(IFERROR(MID($C2,FIND("@",SUBSTITUTE(" "&$C2&" "," ","@",COLUMN($A:$Z))),5),""),SMALL(IF(MATCH(IFERROR(MID($C2,FIND("@",SUBSTITUTE(" "&$C2&" "," ","@",COLUMN($A:$Z))),5),""),IFERROR(MID($C2,FIND("@",SUBSTITUTE...
excel2010怎么将单元格内的组合数据的重复相找出来,不用按照排列顺序...答:选中B列,开始--条件格式--新建规则--使用公式--输入公式:=(COUNTIF(B:B,LEFT(B1,2)&"-"&MID(B1,4,2)&"-"&RIGHT(B1,2))+COUNTIF(B:B,LEFT(B1,2)&"-"&RIGHT(B1,2)&"-"&MID(B1,4,2))+COUNTIF(B:B,MID(B1,4,2)&"-"&LEFT(B1,2)&"-"&RIGHT(B1,2))+COUNTIF(B:...