Is it possible to get list of unique values for data validation. In range a2
- a10 that I use as data validation list i have values x, y, z, x, x, ... In
a drop down I get letter x listed more than one time. Is it possible to make
it unique? I use Excel 2003.

Thanks.

Hi Oscar

Use a different source as your DV list that only has one of each entry.
If your list is as short as you say, then manually typing it would be the
easiest option.

If, in fact it is a much bigger list in reality, then use Advanced filter
Select your source range>Data>Advanced Filter>Unique values only>Copy to new
location say C2
Create a dynamic range for your DV
Insert>Name>Define>
Name myVal
Refers to =$C$2:INDEX($C:$C,COUNTA($C:$C))

--
-------
Regards
Roger Govier

"Oscar" <(E-Mail Removed)> wrote in message
news:173BB29F-B686-4CCA-97AD-(E-Mail Removed)...
> Is it possible to get list of unique values for data validation. In range
> a2
> - a10 that I use as data validation list i have values x, y, z, x, x, ...
> In
> a drop down I get letter x listed more than one time. Is it possible to
> make
> it unique? I use Excel 2003.
>
> Thanks.
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4873 (20100217) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4873 (20100217) __________

The message was checked by ESET Smart Security.

http://www.eset.com

I hoped there is a simple way to get unique values (like autofilter works).
Some WB looks the best way to take care of the list... Thanks anyway, Oscar.

"Roger Govier" wrote:

> Hi Oscar
>
> Use a different source as your DV list that only has one of each entry.
> If your list is as short as you say, then manually typing it would be the
> easiest option.
>
> If, in fact it is a much bigger list in reality, then use Advanced filter
> Select your source range>Data>Advanced Filter>Unique values only>Copy to new
> location say C2
> Create a dynamic range for your DV
> Insert>Name>Define>
> Name myVal
> Refers to =$C$2:INDEX($C:$C,COUNTA($C:$C))
>
> --
> -------
> Regards
> Roger Govier
>
> "Oscar" <(E-Mail Removed)> wrote in message
> news:173BB29F-B686-4CCA-97AD-(E-Mail Removed)...
> > Is it possible to get list of unique values for data validation. In range
> > a2
> > - a10 that I use as data validation list i have values x, y, z, x, x, ...
> > In
> > a drop down I get letter x listed more than one time. Is it possible to
> > make
> > it unique? I use Excel 2003.
> >
> > Thanks.
> >
> > __________ Information from ESET Smart Security, version of virus
> > signature database 4873 (20100217) __________
> >
> > The message was checked by ESET Smart Security.
> >
> > http://www.eset.com
> >
> >
> >
>
> __________ Information from ESET Smart Security, version of virus signature database 4873 (20100217) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>