excel筛选不重复 函数

依次如下：

=IF(SUM(1/COUNTIF($A$2:$A$15,$A$2:$A$15))>=ROW(A1),INDEX($A$2:$A$15,SMALL(IF(ROW($A$2:$A$15)-1=MATCH($A$2:$A$15,$A$2:$A$15,0),ROW($A$2:$A$15)-1,"0"),ROW(A1))),"")

=IF(SUM(1/COUNTIF($A$2:$A$15,$A$2:$A$15))>=ROW()-1,INDEX($A$2:$A$15,SMALL(IF(ROW($A$2:$A$15)-1=MATCH($A$2:$A$15,$A$2:$A$15,),ROW($A$2:$A$15)-1,"0"),ROW($A$2:$A$15)-1)),"")

=IF(AND(COUNTIF(D$1:D1,$A$2:$A$15)),"",INDEX($A$2:$A$15,MATCH(,COUNTIF(D$1:D1,$A$2:$A$15),)))

=INDEX(A2:A15,MATCH(,COUNTIF(E$1:E1,A2:A15),))

=IF(SUM(1/COUNTIF($A$2:$A$15,$A$2:$A$15))>=ROW()-1,INDEX($A$2:$A$15,MATCH(1,--ISNA(MATCH($A$2:$A$15,$F$1:F1,0)),0)),"")

=IF(AND(COUNTIF($G$1:G1,$A$2:$A$15)),"",INDEX($A$2:$A$15,SMALL(IF(FREQUENCY(MATCH($A$2:$A$15,$A$2:$A$15,),MATCH($A$2:$A$15,$A$2:$A$15,))>0,MATCH($A$2:$A$15,$A$2:$A$15,),""),ROW(1:1))))

=IF(SUM(IF($A$2:$A$15<>"",1/COUNTIF($A$2:$A$15,$A$2:$A$15)))>=ROW()-1,INDEX($A$2:$A$15,SMALL(IF($A$2:$A$15<>"",IF(ROW($A$2:$A$15)-1=MATCH($A$2:$A$15,$A$2:$A$15,0),MATCH($A$2:$A$15,$A$2:$A$15,0))),ROW(A1))),"")

=INDEX(A:A,MIN(IF(COUNTIF(B$1:B1,OFFSET($A$2,,,COUNTA($A:$A)-1)),65536,ROW(OFFSET($A$2,,,COUNTA($A:$A)-1)))))&""

=T(INDEX(A:A,MIN(IF(COUNTIF(J$1:J1,OFFSET($A$2,,,COUNTA($A:$A)-1)),65536,ROW(OFFSET($A$2,,,COUNTA($A:$A)-1))))))

=TEXT(INDEX(A:A,MIN(IF(COUNTIF(K$1:K1,OFFSET($A$2,,,COUNTA($A:$A)-1)),65536,ROW(OFFSET($A$2,,,COUNTA($A:$A)-1))))),";;;@")

以上都为数组公式，CTRL+SHIFT+ENTER

============================================================================

=LOOKUP(1,0/ISNA(MATCH(A$2:A$15,L$1:L1,)),A$2:A$15)

=================================================================

补充二个:

=INDEX($A$2:$A$15,SMALL(IF(MATCH($A$2:$A$15,$A$2:$A$15,)=ROW($1:$14),ROW($1:$14)),ROW(1:1)))

=INDEX(A:A,MIN(IF(COUNTIF(M$1:M1,$A$2:$A$15),4^8,ROW($2:$15))))&""