LARGE function
Summary
Returns the k-th largest value in a data set
Syntax
LARGE(array, k)
The LARGE function syntax has the following arguments:
• Array Required. The array or range of data for which you want to determine the k-th largest value.
• K Required. The position (from the largest) in the array or cell range of data to return.
• Array Required. The array or range of data for which you want to determine the k-th largest value.
• K Required. The position (from the largest) in the array or cell range of data to return.
Example
=LARGE(A2:B6,3)
=LARGE(A2:B6,7)
=LARGE(A2:B6,7)