This documentation is archived and is not being maintained.

WorksheetFunction.Small Method

Office 2007
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.


expression.Small(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.


NameRequired/OptionalData TypeDescription
Arg1RequiredVariantArray - an array or range of numerical data for which you want to determine the k-th smallest value.
Arg2RequiredDoubleK - the position (from the smallest) in the array or range of data to return.

Return Value


  • 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.