Data Validation dropdown list - don't want doubles in list

[Ben]

Hello,

I am using excel 2007 and am creating a drop down list by selecting
"Data Validation" and entering a column I have with different names in
it that are repeated over again in no particular order. I need the list
to only contain each name once to select from though. Is there any easy
way to do this?

Thanks,
Ben

 

[Gord Dibben]

Copy the column of names to another sheet.

Advance Filter out duplicates.

Name the range of unique items.

Use that range name as source in DV list on original sheet.


Gord Dibben MS Excel MVP

 

[Herbert Seidenberg]

Excel 2007 Data > Data Tools > Remove Duplicates