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.
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, LARGE(array,1) returns the largest value, and LARGE(array,n) returns the smallest value.
Support and feedback
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for