I am trying to calculate the number of GCSE A-C that my students have. The data is in the format of a list comprising of columns for name,subject and grade. A result for a subject will be per row eg.
Fred, Biology, A
Fred, English, D
Fred, Maths,C
Mary, English, C
Mary, French, B

Any suggestion how to calculate the number of GCSEs per student and maybe if the have maths/englisg.

Thanks.