Inverse Ranking

Hello Julia,

Hope you enjoyed your Microsoft Excel advanced course with Best STL.

Thank you for your question regarding Inverse Ranking.

By default the RANK function will rank data in descending order. You can change the order by adding a 1 as the third option of the formula. Descending is a zero which is the default, whilst a 1 is used for an order which is ascending.

I have attached a file to demonstate this.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer