How to Create a Sorted Unique List in Excel

Traditionally, Excel's Advanced Filter feature would be used to create a unique list based on existing data. Microsoft' recent UNIQUE() function, combined with SORT(), allows you to generate unique lists with a single formula.

Read the full article: TechRepublic