怎么按照日期匹配对应的数据,并且表格进行转换,excle考勤表?答:f2单元格公式:{=IF(SMALL(IF(($A$2:$A$19=$E2)*($B$2:$B$19=DATE(2022,10,F$1)),$C$2:$C$19,1),1)=0,"",SMALL(IF(($A$2:$A$19=$E2)*($B$2:$B$19=DATE(2022,10,F$1)),$C$2:$C$19,1),1))} f3单元格公式:{=IF(LARGE(IF(($A$2:$A$19=$E3)...
怎么按照日期匹配对应的数据,并且表格进行转换,excle考勤表?如图_百度...答:f2公式:{=IF(SMALL(IF(($A$2:$A$19=$E$2)*(DAY($B$2:$B$19)=F$1),$C$2:$C$19,2),ROW()-1)=2,"",SMALL(IF(($A$2:$A$19=$E$2)*(DAY($B$2:$B$19)=F$1),$C$2:$C$19,2),ROW()-1))}再复制到其它单元格。