How to use UNIQUE() to populate a dropdown in Microsoft Excel Your email has been sent Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

To create a drop-down list in Excel, you will use the Data Validation feature. This feature enables you to set specific criteria for the data that can be entered into a cell.