duplicates in drop down list from data validation

[aljiwani]

Hey there,

I have giant excel spreadsheet that I am trying to clean up. I want to make one of the columns (with around 3000 rows and may of them are the same) into a drop down list. However, when I try doing so from the data validation tab, I get duplicates, triplicates, etc. of the same item. Is there a way for me to fix this?

Thank you very much,

Al

[alansidman]

Here's a link to a thread in this forum that should solve your problem

http://www.excelforum.com/excel-form...tion-list.html

[Pepe Le Mokko]

Again, lots of info on the forum if you take a minute to search for it
http://www.excelforum.com/excel-form...tion-list.html

[aljiwani]

Thanks for the response six years later, Pepe. Lol

[Pepe Le Mokko]

How did my attention be attracted to this older thread ?
Too much coffee I guess..
Hope you found an answer though

[aljiwani]

No worries, happens to the best of us Thank you, I believe I did get it solved.