Excel提取唯一值公式大全!

▼数组公式,记得三键录入 =IFERROR(INDEX(A:A,SMALL(IF(MATCH($A$2:$A$15,$A$2:$A$15,)=ROW($A$2:$A$15)-1,ROW($A$2:$A$15)),ROW(A1)))&"","")

原理说明:

▼数组公式,记得三键录入 =IFERROR(INDEX(A:A,MATCH(,COUNTIF($C$1:C1,$A$2:$A$15),)+1)&"","")

原理说明:
MATCH(,COUNTIF($C$1:C1,$A$2:$A$15),)+1

▼奇奇怪怪的公式又增加了 =IFERROR(VLOOKUP(,IF({1,0},0/(COUNTIF(C$1:C1,$A$2:$A$15)=0),$A$2:$A$15),2,),"")

原理说明:
=IFNA(LOOKUP(,0/ISNA(MATCH($A$2:$A$15,$C$1:C1,)),$A$2:$A$15),"")

=UNIQUE(A2:A15)

公式说明:
=IFERROR(LOOKUP(,1/(COUNTIF($C$1:C1,$A$2:$A$15)-1),$A$2:$A$29),"")

=IFERROR(OFFSET($A$2,MATCH(,COUNTIF($C$1:C1,$A$2:$A$15),0)-1,,,),"")

赞 (0)