I have an excel list of people attending some classes I run; each person is
assigned a day and time in a column next to their name. The Day and time
data is not unique. i.e there maybe 8 attendees on Monday at 11:30.

In a seperate worksheet I would like to extract each classes participants
from the list so I can create a more calendar like - schedule of this list.

I cannot use Advanced filter as this wil only work for one class at a time.
Is there a function/formula I can use to pull out the people for a particular
class?