SMALL

Returns the nth smallest element from a data set, where n is user-defined.

Parameter List

Syntax
SMALL(rangenth)
range

The range of values to examine.

nth

The nth smallest element to return.

Examples

SMALL(A1:A3, 1) returns 1