SMALL(k, list)

The SMALL function calculates the k-th smallest value in a set of numbers in list.

For example:

SMALL(2, {19, 7, 1, 18, 10})

returns 7.

See also:

Other statistical functions