Data Validation - List of unique values


O

Oscar

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.
 
Ad

Advertisements

R

Roger Govier

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 said:
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
 
Ad

Advertisements

O

Oscar

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top