SMALL
Returns the k-th smallest value in a data set.
StatisticalStatistics & Analysis
What it does
Returns the nth smallest value.
Syntax
SMALL(array, k)
Arguments
array(range) — Data.k(number) — Position (1=smallest).
Examples
2nd Smallest
Find 2nd lowest score.
FORMULA
=SMALL(A1:A5, 2)
RESULT
20
SAMPLE DATA
| A | |
|---|---|
| 1 | Scores |
| 2 | 10 |
| 3 | 20 |
| 4 | 30 |
| 5 | 40 |
| 6 | 50 |