Averaging Letters and Numbers
 

I'm currently working on a gradebook, and as the british system for
grading is 5a 5b 5c etc. rather than just plain grades, I want to know
what would be the easiest way to create a formula to show the Maximum
grade they've acheived, their lowest grade and their average grade.

Any insights would be appreciated.

Averaging Letters and Numbers
 

One way would be to create a weighted helper column, average that, and
un-weight.

The difficulty comes when you have say 5a and 4a, what is the average of
that, or more precisely, what is the rule for calculating the average?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
I'm currently working on a gradebook, and as the british system for
grading is 5a 5b 5c etc. rather than just plain grades, I want to know
what would be the easiest way to create a formula to show the Maximum
grade they've acheived, their lowest grade and their average grade.

Any insights would be appreciated.