How can I alphabetize a unique result in Google Spreadsheets?

Question

I'm generating a list based on using the UNIQUE function.

How can I get the output to be alphabetized automatically?

mhoran_psprep · Accepted Answer · 2012-07-01 17:21:29Z

up vote 2 down vote accepted

Use Sort and Unique together.

=sort(unique(A:A))

Here are the descriptions of the filter functions for Google spreadsheets.

answered Jul 1 '12 at 17:21

mhoran_psprep
2,3171311

Thanks! that worked exactly like I wanted it to. – Dez Jul 2 '12 at 0:23

1 Answer