How can we rank these students from highest to lowest scores?
Well, one option is to sort the students by average score in descending order.
This works fine, but it’s not dynamic.
Let me undo these last changes and let’s try it out.
The RANK function takes three arguments: number, ref, and an optional argument called order.
This means the highest number will get a rank of “1”.
This reference needs to beabsoluteso that it won’t change as the formula is copied down.
Now each student has a rank.
Now let’s look at how to rank race results.
This time we need to specify order.
The default is zero which calculates a rank in descending order.
