Excel > Functions

SMALL Function

The Excel SMALL function is used to return a value dependent upon its ranking in a range of values. For example, the SMALL function can be used to return the 2nd or 3rd smallest number from a range.

The syntax for the SMALL function is:

=SMALL(array,k)

Argument	Purpose
Array	the range of cells you want to find the k-th smallest value in
K	The position in the range of numbers, from the smallest, that you want to return

The example below shows the SMALL function being used to select values from a range.

Function	Result
=SMALL(A2:A11,2)	6
=SMALL(A2:A11,5)	102
=SMALL(A2:A11,1)	2

Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.

Guides