FUNCTION CATALOGUE / STATISTICAL
SMALL Excel function
Returns the k-th smallest value.
Correct sentence to use
Find the [k]th smallest value in [range].
Modify this query in PlainFormula →Example formula
=SMALL(A2:A25,2)
Returns the k-th smallest value.
Syntax
SMALL(array, k)
Argument signature: array, k
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.