excel如何将多人多天多次打卡记录在同一列中。格式变更为同一个人同...答:D=D2))),"")下拉填充 以前版本,在F2中输入或复制粘贴下列公式 =IF(COUNTIFS($B$2:$B2,$B2,$D$2:$D2,$D2)=1,IFERROR(INDEX($E:$E,SMALL(IF(($B:$B=$B2)*($D:$D=$D2),ROW(E:E)),COLUMN(A:A))),""),"")按三键CTRL+SHIFT+ENTER结束公式输入 下拉填充,右拉填充 ...
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...