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. |
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. |
All times are GMT +1. The time now is 01:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com