Excel去重+排序,从没想到如此简单!
=IFERROR(SMALL(IF(MATCH($A$2:$A$15,$A$2:$A$15,)=ROW($2:$15)-1,$A$2:$A$15),ROW(A1)),"")
=SORT(UNIQUE(A2:A15))
赞 (0)
=IFERROR(SMALL(IF(MATCH($A$2:$A$15,$A$2:$A$15,)=ROW($2:$15)-1,$A$2:$A$15),ROW(A1)),"")
=SORT(UNIQUE(A2:A15))