These functions help identify rankings and extreme values.
RANK.EQ
Purpose
Returns the rank of a number within a list.
Syntax
=RANK.EQ(number,ref,[order])
Example
|
Student |
Marks |
Rank |
|
Amit |
85 |
|
|
Neha |
92 |
|
|
Rahul |
78 |
|
|
Priya |
95 |
|
|
Simran |
88 |
Formula:
=RANK.EQ(B2,$B$2:$B$6,0)
A higher score receives a better rank.
LARGE
Returns the nth largest value.
Syntax
=LARGE(array,k)
Example:
=LARGE(B2:B6,1)
Returns the highest value.
=LARGE(B2:B6,2)
Returns the second-highest value.
SMALL
Returns the nth smallest value.
=SMALL(B2:B6,1)
Returns the smallest value.
=SMALL(B2:B6,2)
Returns the second-smallest value.
Practice
Create a Top 5 Sales Report using RANK.EQ and LARGE.