The SMALL function is one of the statistical functions. It is used to analyze the range of data and find the k-th smallest value.
Syntax
SMALL(array , k)
The SMALL function has the following arguments:
Argument | Description |
---|
array | The selected range of cells you want to analyze. |
k | The position of the number from the smallest value, a numeric value greater than 0. |
Notes
How to apply the SMALL function.
Examples
The figure below displays the result returned by the SMALL function.
