Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Function Help
I am working on a cell validation formula (Data, Validation) where I provide
a list from a specified range. My list will have 10 choices. The form will have three separate validation cells from which they will select their first, second and third choices. As all three cells will show choices A-J, I want to make sure they do no select the same option multiple times. Can my lists that contain the same range, only contain the unselected values from the other list boxes? For Example box one the user selects A, box two should show options B-J. Option Box two, the user selects B, then box three should not show A or B. Can this be done? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Function Help
Would your situation be more easily handled by Option buttons (like in a
survey)? Check out Dave Peterson's code on this website (it builds the form for you): http://www.contextures.com/xlform01.html Does that help? *********** Regards, Ron XL2002, WinXP-Pro "John Jost" wrote: I am working on a cell validation formula (Data, Validation) where I provide a list from a specified range. My list will have 10 choices. The form will have three separate validation cells from which they will select their first, second and third choices. As all three cells will show choices A-J, I want to make sure they do no select the same option multiple times. Can my lists that contain the same range, only contain the unselected values from the other list boxes? For Example box one the user selects A, box two should show options B-J. Option Box two, the user selects B, then box three should not show A or B. Can this be done? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Function Help
See
http://www.contextures.com/xlDataVal03.html In article , John Jost wrote: I am working on a cell validation formula (Data, Validation) where I provide a list from a specified range. My list will have 10 choices. The form will have three separate validation cells from which they will select their first, second and third choices. As all three cells will show choices A-J, I want to make sure they do no select the same option multiple times. Can my lists that contain the same range, only contain the unselected values from the other list boxes? For Example box one the user selects A, box two should show options B-J. Option Box two, the user selects B, then box three should not show A or B. Can this be done? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Function Help
Criminately! Who do I send my contribution to? This is way to cool and does
EXACTLY what I need. Thanks SO much for your help and QUICK response "JE McGimpsey" wrote: See http://www.contextures.com/xlDataVal03.html In article , John Jost wrote: I am working on a cell validation formula (Data, Validation) where I provide a list from a specified range. My list will have 10 choices. The form will have three separate validation cells from which they will select their first, second and third choices. As all three cells will show choices A-J, I want to make sure they do no select the same option multiple times. Can my lists that contain the same range, only contain the unselected values from the other list boxes? For Example box one the user selects รขฌลAรขฌย, box two should show options B-J. Option Box two, the user selects รขฌลBรขฌย, then box three should not show รขฌลAรขฌย or รขฌลBรขฌย. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
Using INDIRECT function to specify source data | Charts and Charting in Excel | |||
DATA VALIDATION IN REVERSE #2 (FOR JULIE D.) | Excel Discussion (Misc queries) |