We can illustrate this technique by adding such a validation data control to the Membership Number column as follows: Select all existing data cells in the column in question.

How to base a data validation dropdown on an array in Excel Now we’re ready to create the data validation dropdown that will display the unique list in column H.