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.

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)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>