Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
series of "list" options
somebody help!!
i need to creat series of drop-down menu with series of data. cell A : cell will have 12 choices (from column X : 12 items) cell B : per each choice in cell A, a dropdown menu with 10 choices each (from colum Y : 10 items per 12 choices from cell A=120 items) column C : per each choice in cell B, an additional dropdown menu with 10 choice each (from column Z : 10 items per 10 choice from cell B=100 items) because "list" option from "data validation" function won't allow "if" function, i can't come up with the right function. please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
series of "list" options
Hi,
You should range name each of your lists with the name that appears in the calling list. Then you should use INDIRECT(name) in the Data, Validation, List, Source box. Simple example: Cell A1 contains a DV list of two names from column X suppose those two choices are US and Canada, create two lists, one for US one for Canada. To make it simple the Canada list will contain two items Toronto and Quebec, say in cell D1:D2 and US with New York and San Francisco in E1:E2. Name the first range Canada and the second range US. In another cell where you want to display one of the two list choose Data, Validation, List and in the Source box enter =INDIRECT(A1) When you choose an item from the list in cell A1, Canada or the US, the list in this second cell will reflect only items from either the Canada or US list. You range name a set of cells by highlighting them and typing the name into the Name Box on the left hand side of the Formula Bar. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Stan" wrote: somebody help!! i need to creat series of drop-down menu with series of data. cell A : cell will have 12 choices (from column X : 12 items) cell B : per each choice in cell A, a dropdown menu with 10 choices each (from colum Y : 10 items per 12 choices from cell A=120 items) column C : per each choice in cell B, an additional dropdown menu with 10 choice each (from column Z : 10 items per 10 choice from cell B=100 items) because "list" option from "data validation" function won't allow "if" function, i can't come up with the right function. please help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
series of "list" options
Shane,thanks.
One Q. is there a rule for naming the subgroup, such as "," "space", or limits on characters? I followed ur example and it worked. unfortunately, some of my selections have 50 characters. Stan "ShaneDevenshire" wrote: Hi, You should range name each of your lists with the name that appears in the calling list. Then you should use INDIRECT(name) in the Data, Validation, List, Source box. Simple example: Cell A1 contains a DV list of two names from column X suppose those two choices are US and Canada, create two lists, one for US one for Canada. To make it simple the Canada list will contain two items Toronto and Quebec, say in cell D1:D2 and US with New York and San Francisco in E1:E2. Name the first range Canada and the second range US. In another cell where you want to display one of the two list choose Data, Validation, List and in the Source box enter =INDIRECT(A1) When you choose an item from the list in cell A1, Canada or the US, the list in this second cell will reflect only items from either the Canada or US list. You range name a set of cells by highlighting them and typing the name into the Name Box on the left hand side of the Formula Bar. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Stan" wrote: somebody help!! i need to creat series of drop-down menu with series of data. cell A : cell will have 12 choices (from column X : 12 items) cell B : per each choice in cell A, a dropdown menu with 10 choices each (from colum Y : 10 items per 12 choices from cell A=120 items) column C : per each choice in cell B, an additional dropdown menu with 10 choice each (from column Z : 10 items per 10 choice from cell B=100 items) because "list" option from "data validation" function won't allow "if" function, i can't come up with the right function. please help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
series of "list" options
Can not contain Spaces, "," etc...
50 characters will be Ok... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "Stan" wrote: Shane,thanks. One Q. is there a rule for naming the subgroup, such as "," "space", or limits on characters? I followed ur example and it worked. unfortunately, some of my selections have 50 characters. Stan "ShaneDevenshire" wrote: Hi, You should range name each of your lists with the name that appears in the calling list. Then you should use INDIRECT(name) in the Data, Validation, List, Source box. Simple example: Cell A1 contains a DV list of two names from column X suppose those two choices are US and Canada, create two lists, one for US one for Canada. To make it simple the Canada list will contain two items Toronto and Quebec, say in cell D1:D2 and US with New York and San Francisco in E1:E2. Name the first range Canada and the second range US. In another cell where you want to display one of the two list choose Data, Validation, List and in the Source box enter =INDIRECT(A1) When you choose an item from the list in cell A1, Canada or the US, the list in this second cell will reflect only items from either the Canada or US list. You range name a set of cells by highlighting them and typing the name into the Name Box on the left hand side of the Formula Bar. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Stan" wrote: somebody help!! i need to creat series of drop-down menu with series of data. cell A : cell will have 12 choices (from column X : 12 items) cell B : per each choice in cell A, a dropdown menu with 10 choices each (from colum Y : 10 items per 12 choices from cell A=120 items) column C : per each choice in cell B, an additional dropdown menu with 10 choice each (from column Z : 10 items per 10 choice from cell B=100 items) because "list" option from "data validation" function won't allow "if" function, i can't come up with the right function. please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
Why is "Recently Used File List" in Excel/word options unavailabl | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) |