I have a spreadsheet with pupils marks on,along with their split levels. The
elvels go (from lowest to highest) 3c, 3b, 3a, 4c, 4b, 4a, 5c, 5b, 5a etc.

Is it possible to work out the everage level a pupil got based on these
split levels? If so how do you do it?

Thanks - please e-mail me directly at

Thanks for the help