LARGE
Returns the k-th largest value in a data set.
StatisticalStatistics & Analysis
What it does
Returns the nth largest value from a range.
Syntax
LARGE(array, k)
Arguments
array(range) — Range of data.k(number) — Position (1 = largest).
Examples
2nd Largest
Find 2nd highest score.
FORMULA
=LARGE(A2:A6, 2)
RESULT
90
SAMPLE DATA
| A | |
|---|---|
| 1 | Scores |
| 2 | 80 |
| 3 | 90 |
| 4 | 100 |
| 5 | 70 |
| 6 | 60 |