Documentation/Calc Functions/LARGE

Function name:
LARGE

Category:
Statistical Analysis

Summary:
Finds the nth largest value in a list of numbers.

Syntax:
LARGE(Data; RankC)

Returns:
Returns a real number or an array of real numbers will be returned which is the RankC-th largest value in the Data.

Arguments:
Data is the array or a reference to the range cells of data.

RankC is a positive integer value or an array or a reference to the cell containing that value which is the ranking of the values in the Data. If RankC is an array, the function becomes an array function.


 * If RankC is negative or larger than the size of Data then the function returns an error value.
 * If RankC or Data contains non-numeric value either being passed as an array or as a reference to the cells containing that value then the function returns a #VALUE! error.

Additional details:
None

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/SMALL SMALL]

[[Special:MyLanguage/Documentation/Calc_Functions/ROUNDUP ROUNDUP]

ODF standard:
Section 6.18.40, part 2

Equivalent Excel functions:
LARGE