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…