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.

--
Regards,
Tom Ogilvy



"Salza" wrote in message
...
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.