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

  • Thread starter Thread starter Ben
  • Start date Start date
B

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
 
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
 
Back
Top