LARGE
The LARGE function is used to return a value dependent upon its ranking within a range of values. For example, the LARGE function can return the 3rd largest number from a range of values.
The syntax for the LARGE function is;
=LARGE(array, k)
Array – the range of cells you want to find the k-th largest value within
K – the position in the range of values, from the largest, you want to return
For example, =LARGE(B2:B10,4) returns the 4th largest number from the range B2:B10.
