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.