EXCEL RANK FUNCTION
Excel RANK Function Introduction
This function returns the rank, the number indicating the rank from a list of numbers in ascending or descending order. Use RANK when you want to provide a rank for items in a list, but you don’t want to sort the list.
Description of Excel RANK Function
Syntax:
=RANK (number, ref, [order])
Parameter list:
- number – the number whose rank you want to find.
- ref – an array of, or a reference to, a list of numbers against you want to find the Rank. Nonnumeric values in ref are ignored.
- order – [optional] whether to rank in ascending or descending order. Default order or if omitted it is 0 = descending order, 1 is ascending order.
Step By Step Guide of RANK Function
In this example,
- Jenu has scored highest mark in the lot so he will get Rank 1 and Roy will get Rank 2 as he is the second highest followed by Rambo Rank 3 , John Rank 4, Kevin Rank 5 and Melvin Rank 6. It means the rank will be sorted in the Descending order (Column C) higher marks will have higher rank.
- If you enter the third parameter 1 you can see the Rank will be sorted in reverse, in ascending order. It means Rank 1 will be Melvin as he has scored the lowest marks in the lot and Kevin Rank 2 followed by John, Rambo, Roy and Jenu.
Key Points
This function has been replaced with new functions that provide improved accuracy and whose names better reflect their usage. The new functions are RANK.AVG and RANK.EQ (new version of RANK function).
As the name suggest RANK.AVG will provide you the rank and if more than one value has the same rank, the average rank is returned.
Although RANK function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.
Excel RANK Function Template/Exercise
- Download RANK Function Template
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
