Documentation/Calc Functions/LARGE

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

LARGE

Category:

Statistical Analysis

Summary:

Returns the Rank_c-th largest value in a data set.

Syntax:

LARGE(Data; RankC)

Returns:

Arguments:

Data is the cell range of data.

RankC is the ranking of the value. If RankC is an array, the function becomes an array function.

Additional details:

Examples:

=LARGE(A1:C50;2) gives the second largest value in A1:C50.

=LARGE(A1:C50;B1:B5) entered as an array function gives an array of the c-th largest value in A1:C50 with ranks defined in B1:B5.

Related LibreOffice functions:

ODF standard:

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)

Equivalent Excel functions: