WorksheetFunction.Small Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

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

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

Show: