Manuals/calci/SMALL
SMALL (arr,j)
Where arr is an array and j is the position in the array or range of data to return.
It calculates values with a particular relative standing in a data set
i.e.the j-th smallest value in a data set.
SMALL
i.e=SMALL(C1R1:C1R9,3) is 9.
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 13 | 9 | ||
| Row2 | 14 | |||
| Row3 | 15 | |||
| Row4 | 9 | |||
| Row5 | 10 | |||
| Row6 | 7 | |||
| Row7 | 26 | |||
| Row8 | 1 | |||
| Row9 | 17 |
