All functions / Statistics
LARGE
The k-th largest value (k = 1 is the maximum).
Syntax
=LARGE(array, k)
Arguments
array: The numbers.k: Position from the top.
Example
=LARGE(B2:B20, 2) → Second-highest value
All functions / Statistics
The k-th largest value (k = 1 is the maximum).
=LARGE(array, k)
array: The numbers.k: Position from the top.=LARGE(B2:B20, 2) → Second-highest value