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?

--

Rodrigo Ferreira

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
--
Gary''s Student
gsnu200710


"Rodrigo Ferreira" wrote:

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?

--

Rodrigo Ferreira

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

"Rodrigo Ferreira" wrote in message
...
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?

--

Rodrigo Ferreira