Microsoft Office Tutorials and References
In Depth Information
Analyzing Data with Percentiles and Bins
The difference between RANK.EQ and RANK.AVG is that if more than one
value is at the same rank, then RANK.EQ will use the larger value, whereas
RANK.AVG will use the average of the values.
Figure 9-16 displays a list of employees and the bonuses they earned. Say
you’re the employee who earned $4,800. You want to know where you rank
in the range of bonus payouts. Cell F4 contains a formula with the RANK.
EQ function: =RANK.EQ(C9,C3:C20). The function returns an answer of 4.
Note that the function was entered without the third argument. This tells the
function to sort the distribution descending in determining where the value
is positioned. This makes sense for determining how close to the top of the
range a value is.
of a value.
Follow these steps to use the RANK function:
1. Enter a list of numerical values.
2. Position the cursor in the cell where you want the result to appear.
3. Enter =RANK.EQ( to start the function.
4. Click the cell that has the value you want to find the rank for, or enter
You can also just enter the actual value.
5. Enter a comma ( ,).
6. Drag the pointer over the list of values, or enter the address of the