software

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?

Try this:

Select B1

Datagt;Validation
Allow: Custom
Formula: =OR(B1=REPT(A1,1),B1=REPT(A1,2),B1=REPT(A1,3),B1=R EPT(A1,4))Am I on the right track here?

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

XL2002, WinXP-Proquot;Katjaquot; wrote:

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

Debra Dalgliesh has an excellent explanation

See
www.contextures.com/xlDataVal02.html

quot;Katjaquot; wrote:

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