News
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.
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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results