SMALL
Returns the k-th smallest value in a data set.
| Category | Statistical |
| Syntax | SMALL(array, k) |
Parameters
| Parameter | Required | Description |
|---|---|---|
array | Required | The range or array of data values. |
k | Required | The rank position from the smallest (1 = smallest, 2 = second smallest, etc.). |
Example
SMALL(A1:A10)
Auto-generated from the EngCanvas function registry.