<< Click to Display Table of Contents >> SMALL (k-th smallest number)

Syntax:

SMALL(Range, k)

Description:

This returns the k-th smallest value in a data set. If k=1, the smallest value will be returned, if k=2, the second smallest value will be returned, etc.

Range is a range with numeric data – usually a reference to a cell range in which numbers are entered.

k determines which number to return.

k must not be smaller than 1 or greater than the total number of values in Range. Otherwise, the function returns a #NUM! error value.

Example:

If A1:A5 contains the values 4, 2, 6, 5 and 9, the following applies:

SMALL(A1:A5, 1) returns 2

SMALL(A1:A5, 2) returns 4

SMALL(A1:A5, 3) returns 5

etc.

See also:

LARGE, MIN, PERCENTILE.EXC/PERCENTILE.INC/PERCENTILE, PERCENTRANK.EXC/PERCENTRANK.INC/PERCENTRANK, RANK.EQ/RANK.AVG/RANK