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. |
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) |