The LARGE function
Returns the k-th largest value in a range: k = 1 is the maximum, k = 2 the runner-up.
Syntax
LARGE(array, k)- array
- The range of numbers.
- k
- The position from the top.
Examples
E1
=LARGE(1C2:C6,22)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Product | Sales | 420 | |
| 2 | North | Shoes | 500 | ||
| 3 | South | Shoes | 300 | ||
| 4 | North | Bags | 250 | ||
| 5 | North | Shoes | 420 | ||
| 6 | South | Bags | 180 |
In plain words: Return 2the second largest of 1the sales in C2:C6.
E1=LARGE(C2:C6,5)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Product | Sales | 180 | |
| 2 | North | Shoes | 500 | ||
| 3 | South | Shoes | 300 | ||
| 4 | North | Bags | 250 | ||
| 5 | North | Shoes | 420 | ||
| 6 | South | Bags | 180 |