Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down menu questions
I'm looking to have an output in an MS-Excel file like this (using drop down
menu): Courses Students ---------- Science John Science Andy Science Beth Likewise, I want to filter the output then by each student e.g. John showing him taking 4 courses (Science, Math, English, Computers). How can I write the "IF" statement for this? and where? Any help is greatly appreciated. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down menu questions
Hi
If your list is in 2 columns like this, where each course name is repeated with the Student name alongside, you don't need any formulae. DataFilterAutofilter Select the dropdown on NameSelect the Student and you will see all of the courses he is taking. Alternatively Select the dropdown on Courseselect Course Name and you will see all the Students enrolled for that course. -- Regards Roger Govier "neostar77" wrote in message ... I'm looking to have an output in an MS-Excel file like this (using drop down menu): Courses Students ---------- Science John Science Andy Science Beth Likewise, I want to filter the output then by each student e.g. John showing him taking 4 courses (Science, Math, English, Computers). How can I write the "IF" statement for this? and where? Any help is greatly appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
3 questions: drop downs and comments | Excel Worksheet Functions | |||
Drop down menu | Excel Worksheet Functions | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |