How to create a sorted unique list in an Excel spreadsheet

Microsoft 365’s UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula.

Image: Aajan Getty Images/iStockphoto

Lists are a fundamental part in almost any Microsoft Excel application, and fortunately, they’re easy to generate. There are two kinds of lists you might encounter: a static list and a list based on natural data. Without running a real poll, I suspect that the latter is the most common. 

SEE: 83 Excel tips every user should master (TechRepublic)

This type of list allows you to create dropdown lists and so on to aid data entry and protect the validity of your data. For instance, you might want to create a dropdown list that allows a user to choose employee or student names rather than typing them manually. This type of list is based on a…

Keep reading the full content on the TechRepublic site.


Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Spread the love

Leave a Comment