Documentation/Calc Functions/SMALL

Function name:
SMALL

Category:
Statistical Analysis

Summary:
Returns the n-th smallest value in a list. If this function is passed as an array function then it will return an array in which values in accordance with the required rank array representing their rank in the list.

Syntax:
SMALL(Data; RankC)

Returns:
Returns the RankC-th smallest value in the Data. It can also be an array of real numbers in the order of the required rank array.

Arguments:
Data is the array or a reference to the range cells of data that contains real numbers. For logical values, TRUE is considered as 1 and FALSE as 0.

RankC is a positive integer value or an array of values, a reference to a single cell, or a reference to a range of cells containing them which is/are the rank(s) of the real numbers in the Data. If RankC is an array, the function becomes an array function.


 * If the Data contains duplicate values then the ranks them incrementally, i.e. if Data is {1,2,3,3,4} then their corresponding ranks will be: 1 - 1, 2 - 2, 3 - 3, 3 - 4, 4 - 5.
 * If RankC is negative or larger than the size of Data then the function returns an error value.

Additional details:
None

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

ODF standard:
Section 6.18.70, part 2

Equivalent Excel functions:
SMALL