WorksheetFunction.Small (Excel)

Returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set.

If array is empty, Small returns the #NUM! error value. If k ≤ 0 or if k exceeds the number of data points, Small returns the #NUM! error value. If n is the number of data points in array, SMALL(array,1) equals the smallest value, and SMALL(array,n) equals the largest value.

Small (Arg1, Arg2)


Dim dblArg2() As Double: dblArg2() = 
Dim dblSmall As Double
dblSmall = WorksheetFunction.Small(Arg1:=, Arg2:=dblArg2())

Arguments

Arg1, Arg2

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

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