Is this possible?

[jonjob]

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 (e-mail address removed)

Thanks for the help