Data Validation List (conditional)

[User]

I'm wondering if this is possible with a data validated list. I'd rather not use VBA code if at all possible.

Column-A represents a data validated drop-down list of 3 values: a,b,c

Column-B to be a conditional data validated drop-down list (right now 3 values maybe a few more in the future). If Column-A = "a" can Column-B present a drop down list of 1,2,3? For any other value in Column-A Column-B yields a blank cell or NA.

Column A Column B
a (select 1,2,3)
b NA
b NA
b NA
a (select 1,2,3)
b NA
a (select 1,2,3)
c NA

 

[Claus Busch]

Hi,

Am Sat, 13 Jul 2013 12:20:29 -0700 (PDT) schrieb User:

Column A Column B
a (select 1,2,3)
b NA
b NA
b NA
a (select 1,2,3)
b NA
a (select 1,2,3)
c NA

please look here:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook DataValidation. Open it into the WebApp or do a
rightclick and download it.


Regards
Claus B.

 

[Claus Busch]

Hi again,

Am Sat, 13 Jul 2013 21:41:50 +0200 schrieb Claus Busch:

https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook DataValidation.

you have to download it. DataValidation does not work in the WebApp


Regards
Claus B.