Use RANK.EQ ()’s optional argument to reverse the ranking results. To learn more about ranking in Microsoft Excel, you can read the following articles: How to calculate rank in an Excel sheet ...

Use RANK.EQ and RANK.AVG: Excel offers two additional ranking functions: RANK.EQ (equivalent to RANK) and RANK.AVG (which assigns the average rank to tied values).

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...