# Documentation/Calc Functions/SMALL

Jump to navigation Jump to search

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