Buzz
How to Use the RANK Function in Excel - Illustrated Examples
Syntax:RANK( number, ref, [order])
Where:
- Number: The value for which you want to find the rank. Required value.
- Ref: An array or reference to a list of numbers. Required value.
Considering an Example
- Scenario Order=0:
To determine the rank of 2 among the numbers in descending order, follow the steps depicted below. Enter the formula =RANK(C6,C6:C11) into cell D6. The result is shown below.
- Case 2: Non-zero Order
We want to determine the ranking of 2 among the numbers in ascending order. In cell D6, input the formula =RANK(C6,C6:C11,1). The result is as shown below.
- Note
- When using the Rank function, be mindful that duplicate numbers may affect the ranking of subsequent numbers. For example, if there are 2 instances of 3 in the list with a ranking of 5, the subsequent numbers will have rankings starting from 7.
The VALUE function is a utility function in Excel that helps convert text strings into numbers. When dealing with a string containing both text and numbers, the VALUE function extracts the numerical part from the string for you.
