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.