How is indirect function used in data validation? On the spreadsheet, select cell C3. On the Ribbon, click the Data tab, then click Data Validation.

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.