Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Lists Problem
I'm able to create lists and validation per contextures.com for one cell. But
now I'd like to create a validation for the next cell based on the results of the first validation results. Cell C9 provides 2 options. Cell C13 provides options based on input selected from C9. Now I want to create a function(?) or validation for cell C15 based on a combination of C9 and C13. -- Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Lists Problem
This site describes what you're wanting
http://www.contextures.com/xlDataval02.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steve" wrote: I'm able to create lists and validation per contextures.com for one cell. But now I'd like to create a validation for the next cell based on the results of the first validation results. Cell C9 provides 2 options. Cell C13 provides options based on input selected from C9. Now I want to create a function(?) or validation for cell C15 based on a combination of C9 and C13. -- Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Lists Problem
Found the site as previously indicated, but not getting the results I would
have expected. Not quite sure of what I'm doing wrong. Thanks. -- Steve "Luke M" wrote: This site describes what you're wanting http://www.contextures.com/xlDataval02.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steve" wrote: I'm able to create lists and validation per contextures.com for one cell. But now I'd like to create a validation for the next cell based on the results of the first validation results. Cell C9 provides 2 options. Cell C13 provides options based on input selected from C9. Now I want to create a function(?) or validation for cell C15 based on a combination of C9 and C13. -- Steve |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Lists Problem
I've added instructions for a third dependent list:
http://www.contextures.com/xlDataVal02.html#Third and that example is now in the sample download file. Steve wrote: Found the site as previously indicated, but not getting the results I would have expected. Not quite sure of what I'm doing wrong. Thanks. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation: Lists | Excel Discussion (Misc queries) | |||
Data Validation Lists | Excel Worksheet Functions | |||
Data Validation Lists | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) |