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.