Julia has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course
Inverse Ranking
Hello STL,
I have a range of figures I would like to rank.
The normal 'rank' function ranks them as the largest number =1, the second largest =2 etc.
However, I would like to rank it so the smallest number =1, the second smallest number =2 etc.
Is there a way to do this in a formula? I don't want to use sort etc afterwards; it has to be in the formula itself (as I'm combining it with a vlookup as the reference data moves about).
Any help will be greatly appreciated,
Julia
RE: 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
Rank example.xlsx
