Ok thanks,
I have decided to include a by gender 5 or more A*-U & 1 or more A*-U
analysis too and set up a test area of 4 pupils marks with data:
In A24 will be their first name, B24 will be their surname, C24 their
gender (M=male, F=Female) and from D24 - M24 will be a list of their
grades (A*- U). D24 - M27 will hold the test grades.
I need it to calculate a BOYS & GIRLS ONLY analysis of pupils getting
5 or more A*-U and 1 or more A*-U (number of boys / girls as well as a
percentage of boys / girls).
Thanks in advance,
Marie.
--
Marie1uk
------------------------------------------------------------------------
Marie1uk's Profile:
http://www.excelforum.com/member.php...o&userid=20984
View this thread:
http://www.excelforum.com/showthread...hreadid=384303