Can A Dropdown list only only show names once if the list has the same name lots of times?

[tonywatsonhelp]

Hi Everyone,
So I've got a document that has lots of columns and I'd like each column to be a dropdown list.
the problem is the simplest way to create this list would be to use another sheet called "All Data"
All data has the same columns as the tab I want the dropdown lists in but the names can show many times

so for example Column H could have 30 rows but 6 of them be steven and 5 Tony etc, I want the dropdown list to be just Tony,Steven once etc.

anyideas if this can be done?
also i'm using this on a mac.

Thanks

Tony

 

[mumps]

I believe that you would have to create a unique list of values for each column. You could then define a range name for each unique list and have the data validation formula refer to the defined name. There's lots of information that you can get on how to do this by doing a quick search for something like "create validation list of unique values".

 

[tonywatsonhelp]

Hi Mumps
I was hoping there might be some clever short cut i'd not come across, but thank for the feed back.

Tony

 

[mumps]

My pleasure.