In the attached file, I have a score table of Form 1.
There are 1A, 1B and 1C classes.
I used RANK to compare the whole form scores (to get the form rank of each student).
But how can I use RANK to compare the class scores (to get the class rank of each student)
Please see the attached Excel file. Thank you!
_rank.xlsx