WorksheetFunction.Small Method
Excel Developer Reference |
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.
Syntax
expression.Small(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
Name | Required/Optional | Data Type | Description |
---|---|---|---|
Arg1 | Required | Variant | Array - an array or range of numerical data for which you want to determine the k-th smallest value. |
Arg2 | Required | Double | K - the position (from the smallest) in the array or range of data to return. |
Return Value
Double
Remarks
- 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.
See Also