SMALL function
SMALL returns the nth smallest value from a set of values.
Syntax
SMALL(array,nth_position)
- array is the cell range of the set of values.
- nth_position is the ranking of the value.
Example
=SMALL(A1:C50,2) gives the second smallest value in A1:C50.