Michael,

Use a Pivot Table. Drag all three buttons to the row area (Rating first)
and then drag either cloas or instructor to the data area (since they are
strings, it will default to count rather than sum). Then you can show
whichever combination of values you want.

HTH,
Bernie
MS Excel MVP

"Michael" wrote in message
news:8zLOd.42933$B95.11631@lakeread02...
Hi Folks - I've seen similar requests, but not exactly what I was looking
for. I have a list:

Class Instructor Rating
Excel Smith 5
Access Jones 4
Excel Brown 3

etc.....


I can use the Frequency function to determine how many 3, 4 and 5 ratings
I
get for the entire list. I'd like to be able to filter the list by class
and
instructor, and the get the frequency data for the filtered list. Any
ideas?

Thanks.

Michael