Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validy check in one coulmn to limit input options in another?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validy check in one coulmn to limit input options in another?
Try this:
Select B1 DataValidation 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-Pro "Katja" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validy check in one coulmn to limit input options in another?
Debra Dalgliesh has an excellent explanation
See http://www.contextures.com/xlDataVal02.html "Katja" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input box | Excel Discussion (Misc queries) | |||
How to set the autofill options in a column of a input data table | Excel Discussion (Misc queries) |