The function Large returns the value of the specified location from a range of cells when sorted from largest to smallest, starting at 1 for the largest.
Syntax:
= Large(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 largest value.
Location. is the position (from the largest value) in the array or range of the value to return.