The information I am attempting to process has been given to me as a single row per exam result. I need to calculate the number of [A/B/C] grades and [D/E/F] grades that a student has. I have managed to do this with countIFs which has provided me with the results against each row. eg. Calculating the number of A/B/C's that a student has column where Fred has 3 A/B/C and Joe has 1 A/B/C.

FRED Maths A 1
FRED English A 2
Joe Maths C 1
FRED French B 3
Joe English D 1

The problem is that now I need to remove rows for the same student as I am not interested in the actual subjects just the totals. There is an unknown number of names and results. What I then would like to produce is the number of students with [less than 5 GCSEs], [5 or more GCSEs], [5 or more GCSEs with English], [5 or more GCSEs with Maths], [5 or more GCSEs with Maths & English], and so on. I need to do this analysis for approx. 10 years of results for several sites to see if there is a pattern etc. The alternative could be VBA code? Any suggestion etc - what is the best/quickest method.