Excel去除重复值的五种公式!你都会吗?答:D3-G3单元格公式:输入完之后按三键CTRL+SHIFT+ENTER =INDEX(A:A,SMALL(IF(MATCH(A$2:A$20,A$2:A$20,)=ROW($1:$19),ROW($2:$20),4^8),ROW(A1)))&""=INDEX(A:A,MIN(IF(COUNTIF($E$2:E2,$A$2:$A$20),4^8,ROW($A$2:$A$20)))&""=IF(SUM(N(COUNTIF($F$2:...
EXCEL中A&B去重复,如图?答:=INDEX(A:A,SMALL(IF(MATCH($A$1:$A$8&$B$1:$B$8,$A$1:$A$8&$B$1:$B8,)=ROW($A$1:$A$8),ROW($A$1:$A$8),2^20),ROW(A1)))&""或者加个标题,可以换个更简单一点的公式:D2填入,向右向下填充。=INDEX(A:A,MATCH(,COUNTIFS($D$1:$D1,$A:$A,$E$1:$E1,$...