Thread: Percentage

I have the following simple spreadsheet example (the actual list contains hundreds of pupils and more subjects)

Name Subject Grade
Gary Maths 2
English 2
Physics 2
History 3
Jane Maths 5
History 2
Geography 5
English 4
Paul Science 2
Maths 5
Physics 4
Sarah Maths 2
History 2
English 1
Physics 2


What i would like to do is work out what percentage of pupils achieved a grade 2 or better in 3 or more different subjects. I am having difficulty because some pupils only have 4 subjects, some have 3, some have 5 and so on. Any help would be greatly appreciated.

I have the following simple spreadsheet example (the actual list contains hundreds of pupils and more subjects)

Name Subject Grade
Gary Maths 2
English 2
Physics 2
History 3
Jane Maths 5
History 2
Geography 5
English 4
Paul Science 2
Maths 5
Physics 4
Sarah Maths 2
History 2
English 1
Physics 2


What i would like to do is work out what percentage of pupils achieved a grade 2 or better in 3 or more different subjects. I am having difficulty because some pupils only have 4 subjects, some have 3, some have 5 and so on. Any help would be greatly appreciated.

Originally Posted by vikas.bhandari

I would do something like attached One. I am sure there might be a better solution. I have done it through Pivot and a formula.

Thanks,
Vikas

thanks for the reply. I dont need to work out each individual pupils average. I need to count how many passes each pupil gets at level 2 or better ( 1 being the best) and then calculate what average of the total number of pupils achieved a pass at 2 or better in at least 3 subjects

If your happy running a macro.
This could be a starting point.

Regards
Alistair