FUNCTION CATALOGUE / STATISTICAL
LARGE Excel function
Returns the k-th largest value.
Correct sentence to use
Find the [k]th largest value in [range].
Modify this query in PlainFormula →Example formula
=LARGE(A2:A25,2)
Returns the k-th largest value.
Syntax
LARGE(array, k)
Argument signature: array, k
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.