You can easily sort the UNIQUE
results in Google Sheets using this formula:=UNIQUE(SORT(A1:A13))
![](https://i0.wp.com/sheetslogy.com/wp-content/uploads/2022/10/7_SortUnique_1.gif?resize=572%2C522&ssl=1)
Simply replace A1:A13
with your data range and you should be able to sort the results from UNIQUE
in ascending order (A-Z).
To sort in descending order, use this formula:=UNIQUE(SORT(A1:A13,1,false))
![](https://i0.wp.com/sheetslogy.com/wp-content/uploads/2022/10/7_SortUnique_2.gif?resize=445%2C519&ssl=1)
1
refers to the column to be sorted. In this case, just use 1.False
sets the sort order to descending order (Z-A).