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.