Google Sheets – How to Alphabetize Unique Results

google sheetssorting

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

How can I get the output to be alphabetized automatically?

Best Answer

Use Sort and Unique together.

=sort(unique(A:A))

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