Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for text
I am using Excel for course scheduling. I have a drop-down menu in one
column with departments. If the user selects a given department, I would like the next column then to have a drop down menu showing them the names of courses available in their department only (rather than one huge list of all the course names from all departments). I do not know whether Excel has a formula that might work for this instance? If anyone has ideas, I would be most grateful. Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for text
See http://www.contextures.com/xlDataVal02.html
-- __________________________________ HTH Bob "Betty S" <Betty wrote in message ... I am using Excel for course scheduling. I have a drop-down menu in one column with departments. If the user selects a given department, I would like the next column then to have a drop down menu showing them the names of courses available in their department only (rather than one huge list of all the course names from all departments). I do not know whether Excel has a formula that might work for this instance? If anyone has ideas, I would be most grateful. Thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for text
Bob -- absolutely wonderful. Just what I needed. Thanks a million. -betty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
match cell text with text in formula | Excel Worksheet Functions |