<-- Previous || Up || Next -->

Large Function
Math Statistics Class

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

Returns the Nth largest number within vValues.

    Large(1, 34, 56, 12) = 56
    Large(2, 34, 56, 12) = 34
    Large(3, 34, 56, 12) = 12
    Large(1, SampleData) = Maximum(SampleData)
See also:
    Small Function
    Rank Function
    Percentile Function
    PercentRank Function
    Maximum Function
    LARGE Function (Microsoft Excel)
vN: The Nth largest 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 largest 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.

Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.