SMALL Function
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.
