This post will guide you how to rank data in reverse order in Excel. You can use the RANK function to rank data in excel, and the biggest value will be ranked as 1 by default. How to reverse this rank order and lets the smallest value be ranked as 1. How to achieve it in excel.
Reverse Rank Order
Assuming that you have a formula based on RANK function that ranks numbers by biggest to smallest by default. But you want to go the opposite from the smallest to biggest. So you need to reverse the rank order to achieve it.
To reverse rank order in excel, you just need to add one more argument in the Rank function, just like this formula:
=RANK(B1,$B$1:$B$B5,1)
You will see that the rank order has been reversed.
Related Functions

Excel Rank function
The Excel RANK function returns the rank of a given number in a supplied range of cells. If there are duplicated values in a list of values, it will be set the same rank.The syntax of the RANK function is as below:= RANK (number,ref,[order])….
Related Posts
Sort/Rank Numeric Values with Duplicate Values Exist
Excel builtin RANK function can sort a set of values. If there are duplicate numbers, then the rank number is also duplicated. See the following example: There are two numbers “100” in range A2:A9, they are both the third largest ...
Calculate Days Open in Excel
If you want to know how to Calculate days in Excel, there are some formulas that you can use to do so. For example, you can use the DAYS function in Excel to find the number of days between two ...
Calculate Grades With VLookup in Excel
Why Should You Calculate Grades With VLookup Excel? If you're looking for a simple way to find out a student's grades, VLOOKUP Excel can do the trick. This function uses a lookup table to find the values and sort them ...
Repeating Character n Times in Excel
In daily life, we can use repeated characters to indicate the magnitude or priority of something. For example, a single “!” indicates a minor case, double “!!” indicates a medium case, and triple “!!!” indicates a high case, and so ...
Calculate Cumulative Loan Interest in Excel
What is Cumulative Loan Interest? When comparing different types of loans, many people want to know what is Cumulative Loan Interest. The sum of all interest payments you've made on a loan is referred to as cumulative interest. Different lenders ...
Comments
So empty here ... leave a comment!