Edit

Share via


WorksheetFunction.Small(Object, Double) Method

Definition

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.

public:
 double Small(System::Object ^ Arg1, double Arg2);
public double Small (object Arg1, double Arg2);
Public Function Small (Arg1 As Object, Arg2 As Double) As Double

Parameters

Arg1
Object

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.

Returns

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.

Applies to