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