LARGE function

LARGE returns the nth largest value from a set of values.

Syntax

LARGE(array,nth_position)

  • array is the cell range of the set of values.
  • nth_position is the ranking of the value.

Example

=LARGE(A1:C50,2) gives the 2nd largest value in A1:C50.