LARGE

Name

LARGE —
LARGE(n1, n2, ..., k)

Description

LARGE returns the k-th largest value in a data set.

If data set is empty LARGE returns #NUM! error. If @k <= 0 or @k is greater than the number of data items given LARGE returns #NUM! error.

See also

PERCENTILE , PERCENTRANK , QUARTILE , SMALL