SMALL

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.

Syntax

SMALL(array,k)

Array   is an array or range of numerical data for which you want to determine the k-th smallest value.

K   is the position (from the smallest) in the array or range of data to return.

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.

Example

SMALL({3,4,5,2,3,4,5,6,4,7},4) equals 4

SMALL({1,4,8,3,7,12,54,8,23},2) equals 3