Returns the k-th largest value in a data set.
الصيغة
LARGE(array, k)المعاملات
arrayمطلوب
The array or range of data for which you want to determine the k-th largest value.
kمطلوب
The position (from the largest) in the array or cell range of data to return.
The LARGE function identifies the value at a specific rank within a range or array of numbers. It is useful for finding top-performing data points, such as the highest or second-highest scores in a list.
=LARGE({10, 20, 30, 40}, 2)→30Returns the 2nd largest number from the provided array.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =LARGE( and select your data range, followed by a comma and the rank k.
Complete the function
Close the parenthesis and press Enter to see the result.
The function will return a #NUM! error.