The Excel SMALL function is used to return a value dependent upon its ranking in a range of values. For example, the SMALL function can be used to return the 2nd or 3rd smallest number from a range.
The syntax for the SMALL function is:
=SMALL(array,k)
| Argument | Purpose |
|---|---|
| Array | the range of cells you want to find the k-th smallest value in |
| K | The position in the range of numbers, from the smallest, that you want to return |
The example below shows the SMALL function being used to select values from a range.
| Function | Result |
|---|---|
| =SMALL(A2:A11,2) | 6 |
| =SMALL(A2:A11,5) | 102 |
| =SMALL(A2:A11,1) | 2 |
