Data Validation

[Jack]

I need to do a validation on a subset of a list. My data is as follows

In A1 is the Value "AL"
in B1 i would like to validate based on the below data in A5:B9, but i only
want the values for state AL - Autauga and Baldwin to show in the Validation.

State County
AK YAKUTAT BOROUGH
AK YUKON-KOYUKUK
AL AUTAUGA
AL BALDWIN

 

[Eduardo]

Hi,
Look into Debra Web page she has an excellent example

http://www.contextures.com/xlDataVal02.html

Hope this help

 

[Sheeloo]

In a separate sheet set up 'Names' matching the options in the first col...
and options in the second col as the range

See http://www.contextures.com/xlDataVal02.html for an excellent description
on how to do this.

 

[Jack]

the sample seems to indicate the only way to do this is to have the data in
seperate columns. the table i have is for all 50 states - is there any way
to do this with a filter and not change the data table?

 

[Jack]

I did some more reading and found the answer under
http://www.contextures.com/xlDataVal13.html

Thanks for pointing me in the right direction.
Jack