Documentation/Calc Functions/SMALL

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.

None

Examples:

Data1 Data2 RankC
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
=SMALL(A1:B6;2) The function gives the second smallest value in A1:B6. 148
=SMALL(A1:B6;C1:C5) it is entered as an array The function gives an array of the c-th smallest value in A1:B6 with ranks defined in C1:C5. 148
144
151
154
165
=SMALL(A1:B6;{2;1;-3;4;5}) it is entered as an array For -3 value of rank the function returns a value error keeping rest of the result same. 148
144
#VALUE!
154
165

SMALL