Documentation/Calc Functions/LARGE

From The Document Foundation Wiki
Jump to navigation Jump to search


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

Examples:

Data1 Data2 Rank
1 195 200 2
2 151 180 1
3 148 178 3
4 189 165 4
5 183 192 5
6 154 144
Formula Description Returns
=LARGE(A1:B6;2) The function gives the second largest value in A1:B6. 195
=LARGE(A1:B6;C1:C5) or =LARGE(A1:B6,{2;1;3;4;5}) it is entered as an array The function gives an array of the c-th largest value in A1:B6 with ranks defined in C1:C5. 195
200
192
189
183

Related LibreOffice functions:

SMALL

ROUNDUP

ODF standard:

Section 6.18.40, part 2

Equivalent Excel functions:

LARGE