WorksheetFunction.Small Method (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.
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.