Validy check in one coulmn to limit input options in another?

K

Katja

I would like to limit input options in one column depending on the entry in
another column (e.g. column 1 has input possibilities a, b, or c; if the
input is a, the options in column 2 should only be aa, aaa, or aaaa; if it is
b, only bb, bbb, or bbbb, etc. ...). How can I achieve this?
 
R

Ron Coderre

Try this:

Select B1

Data>Validation
Allow: Custom
Formula: =OR(B1=REPT(A1,1),B1=REPT(A1,2),B1=REPT(A1,3),B1=REPT(A1,4))


Am I on the right track here?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top