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

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