SMALL function returns the nth smallest value in a range. LARGE function returns the nth largest value in a range.

Examples:

=LARGE(A5:A10,2)
Returns the 2nd largest value in the range

=SMALL(C5:C10,3)
Returns the 3rd smallest value in the range

Simplified syntax:

=SMALL(range,k)
=LARGE(range,k)

• Where  k  is the “nth” place desired value.
• k can be a reference to another cell.
• SMALL/LARGE ignores empty cells, text values, and TRUE and FALSE values.
• If the range contains no numeric values, a #NUM! error is returned.