Ranking Grades

[Salza]

Hi all....

I am doing an exam marksheet.
There are nine grades for each subject, namely A to I, where A is the best.

Column A shows students' names.
Columns B to J shows numbers of Grade A, B, C, D, E, F, G, H, I each student
scores.

What is the formula for RANKING students achievement according the best
numbers of A, followed by B to I.?
This is to decide the position in class.

Thanks for your help.

 

[Tom Ogilvy]

You would need to create a composite score which weights the individual
letter grades. Or you would need to sort the data, using the lowest three
letters as keys first (G, H, I) then the next three (D, E, F) and so forth.
Each key should be sorted descending.