SMALL

Name

SMALL —
SMALL(n1, n2, ..., k)

Description

SMALL returns the k-th smallest value in a data set.

If data set is empty SMALL returns #NUM! error. If @k <= 0 or @k is greater than the number of data items given SMALL returns #NUM! error.

See also

PERCENTILE , PERCENTRANK , QUARTILE , LARGE