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.