WorksheetFunction.Large method (Excel)
Returns the k-th largest value in a data set. 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.
expression.Large (Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
| 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. |
Double
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, LARGE(array,1) returns the largest value, and LARGE(array,n) returns the smallest value.
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.