 | LARGE function |
Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.
Syntax
LARGE(array,k)
Argument | Description | Remarks |
|---|---|---|
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. |
|
General remarks
If n is the number of data points in a range, then LARGE(array,1) returns the largest value, and LARGE(array,n) returns the smallest value.
Example
To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.
|
|
