Hi there, hoping someone can answer what is probably a very easy solution...
I am using data validation to create a dropdown list, however my data list has duplications. Is there a way for the list not to show duplications?
Hi there, hoping someone can answer what is probably a very easy solution...
I am using data validation to create a dropdown list, however my data list has duplications. Is there a way for the list not to show duplications?
make a pivot table based on the column (no duplicate values will be listed), and make the data validation based on the pivot table output.
Please click the * icon below if I have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks