← Guides

UNIQUE and SORT in Excel

=UNIQUE(A2:A1000)
=SORT(UNIQUE(A2:A1000))
=SORT(UNIQUE(FILTER(A2:B100,C2:C100="Open")),2,-1)

Clear cells below/right if you get #SPILL!.

Remove duplicates · Directory