LARGE

Returns the nth largest element from a data set, where n is user-defined.

Parameter List

Syntax
LARGE(rangenth)
range

The range of values to examine.

nth

The nth largest element to return.

Examples

LARGE(A1:A3, 1) returns 3