Filter by Class

This thread relates to this http://www.excelforum.com/excel-prog...ed-filter.html thread I started.

I started this new thread for clarity.

Attached is a sample worksheet. I have made it small to be practical.

Essentially what my intention was is to filter the data on "Datasheet" by class. Count the number of members in each class(used to work out averages) and create a table for each class of final results variation from average etc on another sheet. In this workbook that sheet is call "SampleOut".

Any feedback ideas on the best way to acheive this is appreciated.

Thanks

Sayth