All functions / Statistics
SMALL
The k-th smallest value (k = 1 is the minimum).
Syntax
=SMALL(array, k)
Arguments
array: The numbers.k: Position from the bottom.
Example
=SMALL(B2:B20, 1) → Lowest value
All functions / Statistics
The k-th smallest value (k = 1 is the minimum).
=SMALL(array, k)
array: The numbers.k: Position from the bottom.=SMALL(B2:B20, 1) → Lowest value