CODEWITHSUNDEEP
excelexcel-formula
user14380579
user14380579

Reputation:

Return all unique values from column, and sort them alphabetically

So I've so far created a formula that returns all unique values from a column. In this case, the B column is the the list of values, and the D column is populated with a formula, returning all unique values from column B.

The formula is:

=INDEX(Table1[System], MATCH(0, COUNTIF($D$2:D2, Table1[System]), 0))

This is entered into cell D3 and dragged all the way down.

I'm just wondering if there's a way to amend this so that it returns all the values in alphabetical order? (without just reordering column B)

enter image description here

Upvotes: 1

Views: 5260

Answers (1)

Harun24hr
Harun24hr

Reputation: 36850

With ExcelO365 you can use SORT() function with UNIQUE() in this way. For other version it will complex to sort.

=SORT(UNIQUE(A2:A11))

enter image description here

Upvotes: 3

Related Questions