Now we’re ready to create the data validation dropdown that will display the unique list in column H. To begin, select J2 and then do the following: Click the Data tab.

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.

In the Data Tools section, click the Data Validation button, and select the same option again. Now, expand the Allow drop-down list, and select List . Then, you need to write down all the options ...

Excel will display the cell reference for the entire data set or Table object as the List Range. If you retain this selection, Excel will return a unique data set based on all the columns.