Now, let’s use this function to create a unique list. How to create a unique list in Excel. Microsoft Excel supports two different dropdowns: Data Validation and a combo box control.

How to use the UNIQUE() function in Excel. If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE() function.

In Excel 365, the “Unique” function filters out repeated items, showing only those appearing exactly once, while the “Distinct” function lists all distinct items, regardless of frequency.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.