Function Math Statistics Class

Small

Returns the Nth smallest number within vValues.

Signature (Visual Basic / VBA)

Public Function Small( _
      ByVal vN As Variant _
    , ParamArray vValues() As Variant _
    ) As Variant

Code Example

    Small(1, 34, 56, 12) = 12
    Small(2, 34, 56, 12) = 34
    Small(3, 34, 56, 12) = 56
    Small(1, SampleData) = Minimum(SampleData)

Parameters

Parameter Description
vN The Nth smallest number when all of the numeric arguments are sorted.
vValues The values that are to be processed. Can be numbers, one-dimensional numeric arrays, one-dimensional Variant arrays, one-dimensional Variant arrays with embedded arrays, or any combination of these. The current setting of the StatVarType Property determines which numeric data types are recognized by this function.

Return Value

Function returns the Nth smallest of the numeric values. Function returns Null if none of the arguments are numeric, or if vN is not within the count of numeric values inclusive.