Rank function used for ranking a value among a range and return a ranking number. The ranking number which will return, depends on which option you would like to mention. There are 2 options. For largest to smallest (0), and another one is smallest to largest (1).
Rank Function:
The structure of this function is:
Function Details:
There are 3 arguments in this function. First 2 is essential and last one is optional. These are described as below:
number: It is mandatory. This is a single number, which you would like to find what is the position of this number.
ref: Reference is another mandatory part. It refers a cell range. The number will find the position comparing this ref range.
[order]: It is optional. You can mention 0 or 1 if you wish. Or else it will select 0 (zero) by default which means: Large number is number 1. If you mention 1, then this will work as smallest number is number 1.
Example # 1:
Below table A1:B5 shows the salary of the football players. Now make a ranking of Top 3 (largest to smallest).
Use the Rank function in Rank column C2 cell and copy down to the C5 cell:
See, Ronaldo is in top paid player, then Messi and then Neymar. For better result, make a sort as ascending order.
Example # 2:
Depending on the same table, at this time make a ranking of Bottom 3 (smallest to largest).
Use the Rank function in Rank column C2 cell and copy down to the C5 cell:
Ronaldo is in number 4 if bottom top result we see. Balak is in number 1, then Neymar 2, and then Messi 3.
Rank Function:
The structure of this function is:
=Rank(number,ref,[order])
Function Details:
There are 3 arguments in this function. First 2 is essential and last one is optional. These are described as below:
number: It is mandatory. This is a single number, which you would like to find what is the position of this number.
ref: Reference is another mandatory part. It refers a cell range. The number will find the position comparing this ref range.
[order]: It is optional. You can mention 0 or 1 if you wish. Or else it will select 0 (zero) by default which means: Large number is number 1. If you mention 1, then this will work as smallest number is number 1.
Example # 1:
Below table A1:B5 shows the salary of the football players. Now make a ranking of Top 3 (largest to smallest).
Image 1: Sample data
Use the Rank function in Rank column C2 cell and copy down to the C5 cell:
=RANK(B2,B$2:B$5,0)
Image 2: Applying the Rank function
See, Ronaldo is in top paid player, then Messi and then Neymar. For better result, make a sort as ascending order.
Image 3: Example of Rank
Example # 2:
Depending on the same table, at this time make a ranking of Bottom 3 (smallest to largest).
Image 4: Sample data
Use the Rank function in Rank column C2 cell and copy down to the C5 cell:
=RANK(B2,B$2:B$5,1)
Image 5: Example of Rank
Ronaldo is in number 4 if bottom top result we see. Balak is in number 1, then Neymar 2, and then Messi 3.