Function to extract data from a list

[sot]

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?

 

[Gary''s Student]

If the day & time are in column B, we want to extract ALL the people who are
Monday 10:00 AM into a single table. The usual lookups will only return the
first found item in the list. To get all the items, see:

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

Simpler approaches would be to sort on the day/time column or use AutoFilter.

 

[Herbert Seidenberg]

Excel 2007
Multiple Pivot Tables
http://www.mediafire.com/file/zmomivtugyz/03_04_09a.xlsx