Drop down menu questions

N

neostar77

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

Roger Govier

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.
Data>Filter>Autofilter
Select the dropdown on Name>Select the Student and you will see all of the
courses he is taking.
Alternatively
Select the dropdown on Course>select Course Name and you will see all the
Students enrolled for that course.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking up with more than 1 criteria 5
i need an excel wizard 2
Multiple Dependent Drop Down Menu? 4
Selecting Multiple items from drop down list 5
HELP !!!! excel question 2
i need an EXCEL wizard 2
Design assistance needed (badly) 7
Drop Down Menu Question 3

Top