The function small returns the value of the specified location from a range of cells when sorted from smallest to largest, starting at 1 for the smallest.

Syntax:

=Small (range of cells, location)

Range of cells. is an array or range of cells containing numerical data for which you want to determine the N-th smallest value.

Location. is the position (from the smallest value) in the array or range of the value to return.