Excel functions

The SMALL function

Returns the k-th smallest value in a range: k = 1 is the minimum.

Syntax

SMALL(array, k)

array: The range of numbers.
k: The position from the bottom.

Examples

E1=SMALL(¹C2:C6,²1)

	A	B	C	D	E
1	Region	Product	Sales		180
2	North	Shoes	500
3	South	Shoes	300
4	North	Bags	250
5	North	Shoes	420
6	South	Bags	180

In plain words: Return the smallest of the sales in C2:C6.

E1=SMALL(C2:C6,2)

	A	B	C	D	E
1	Region	Product	Sales		250
2	North	Shoes	500
3	South	Shoes	300
4	North	Bags	250
5	North	Shoes	420
6	South	Bags	180

Related functions