WorksheetFunction.Large Method
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
expression.Large(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | Array - the array or range of data for which you want to determine the k-th largest value. |
| Arg2 | Required | Double | K - the position (from the largest) in the array or cell range of data to return. |
Return Value
Double
Remarks
- If array is empty, LARGE returns the #NUM! error value.
- If k ≤ 0 or if k is greater than the number of data points, LARGE returns the #NUM! error value.
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.