# Documentation/Calc Functions/SMALL

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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

## 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 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

SMALL