WorksheetFunction.Large (Excel)

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.

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.

Large (Arg1, Arg2)

Dim dblArg2() As Double: dblArg2() = 
Dim dblLarge As Double
dblLarge = WorksheetFunction.Large(Arg1:=, Arg2:=dblArg2())

Arguments

Arg1 - Array - the array or range of data for which you want to determine the k-th largest value

Arg2 (Double) - K - the position (from the largest) in the array or cell range of data to return.