Hi there,

I am a teacher and need to analyse my results for review and target
setting purposes.

I need the spreadsheet to generate results for the following:

Number of pupils scoring 5 grades (or higher) A* - C
% of pupils scoring 5 grades (or higher) A* - C
Number of pupils scoring 5 grades (or higher) A* - G
% of pupils scoring 5 grades (or higher) A* - G
Number of pupils scoring 1 (or higher) grade A*-G
% of pupils scoring 1 grade (or higher) grade A* - G
Number & % of pupils who were absent

In column A will be the pupil's first name, column B will be their
surname, C their gender and in columns D - O will be where I will input
their grades (not all cells D - O will necessarily be used). Using this
format what is the best formula for obtaining the necessary results?

Many thanks for your consideration,

Marie.


--
Marie1uk
------------------------------------------------------------------------
Marie1uk's Profile: http://www.excelforum.com/member.php...o&userid=20984
View this thread: http://www.excelforum.com/showthread...hreadid=384303