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 |