validation list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

column A contains numerous numbers. i want to create a validation list in another cell using this list
i know how to create the list but i would like to know if it can leave out the duplicate numbers. this list may
have 50 or more numbers in it, and some are the same. i would like my pull down list to show only 1 of each #.
thank you in advance
example:
4030
4030
403
203
203
187
402
4027
 
Brian

One method.

Select the column of numbers.

Data>Filter>Advanced Filter

Choose "Copy to another location".

For the List range, select the column from which you want to extract the
unique values.

Leave the Criteria Range blank.

Select a starting cell for the Copy to location.

Check mark in the "Unique records only" box.

OK your way out.

Use the copied list in your Data Validation.

You could copy to another worksheet and give the list a defined Name and use
it as the DV list.

Gord Dibben Excel MVP
 
Back
Top