Class Results Based on Teacher

[Darth_Williams]

Good morning,

Is there a way to create a summary sheet where I could enter a teachers name say in cell B2 and a table below will automatically populate with each students name and the grades they have in each topic?

I can make this work for one student but ideally I need to make it bring back every student that teacher is in charge of and I'm not ashamed to admit to being stumped

I have the main data sorted and I know that this is easily achieved with filters, but the powers that be want to see this on a summary page instead of using filters.

Any help will be appreciated.

Thank you

 

[Finalfight40]

Thought I'd give something a try and you can do something like this if you want to keep the row:

=SUBSTITUTE(FILTER(B3:D6, (B3:B6="A")), 0, "")

Where the green part would be your filter function.