validation list with no duplicates

  • Thread starter Thread starter Rodrigo Ferreira
  • Start date Start date
R

Rodrigo Ferreira

Hi,
How can I create a validation list with no duplicates?
I have the list:

A
ABC
DEF
GHI
ABC
DEF
ZXC
....

On B3 I want a validation list with:
ABC
DEF
GHI
ZXC

How can I do this?
 
Say your original data ( with duplicates ) is in column A.
Data > Filter > Advanced Filter > Unique records only
and specify, say, column C

Then in B3 insert Data validation pointing to column C rather than column A
 
You have to create a 2nd list that contains just the unique entries.

One way to do that is to use the Advanced Filter to extract the unqiues and
choose to copy those uniques to another location. Then use that new range
location as the source for the drop down.

Biff
 
Back
Top