• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Populate Drop Down Validation List With Data Table Contents (No Duplicates)

M

Mike Langlois

Member
Hey all,

Hopefully my title gave a good idea of what I am aiming to achieve.

I have a data table that contains a column of names of colleagues. This list could contain 2 people or 50. Names can also repeat on this list.

Is there a way to have a drop down validation list populate with all the unique names in that data table column, updating with new names / removing names if they are changed in the data table?

I am able to create helper columns if need be.

Thanks
 
Hi Mike,
I think there are a lot of good ways to get a unique list for data validation. I have attached a simple example that I use. Again there are many ways and I'm certain ways better than this example.

Actual source is from a contributor on this site: I saved formula from another thread once upon a time to learn from and have been using it since. This version uses Named ranges and a helper cell. I'll look for the source of the formula and link to it.
 

Attachments

  • Unique List Validation.xlsx
    11.4 KB · Views: 18
Awesome Wally said:
Hi Mike,
I think there are a lot of good ways to get a unique list for data validation. I have attached a simple example that I use. Again there are many ways and I'm certain ways better than this example.

Actual source is from a contributor on this site: I saved formula from another thread once upon a time to learn from and have been using it since. This version uses Named ranges and a helper cell. I'll look for the source of the formula and link to it.
Click to expand...

Thanks much very for the example. I should be able to modify it to what I need. I am a little worried however that my data table could go 1000+ rows, will this formula provide serious slow down for the sheet if it does?
 
Sorry for the delay in response. I would not anticipate the formula slowing the workbook down too much. I use similar on a file with ~700 rows without noticeable slowdown. If the solution does cripple your speed considerably comment back and we can find a work around with another option.
 
You must log in or register to reply here.
Back
Top