SMALL function in Excel

SMALL returns the k-th smallest value.

Syntax

=SMALL(array, k)

Argument	Required?	What it is
array	Required	The range or array to work on.
k	Required	The position: 1 for the largest or smallest, 2 for the second, and so on.

=MAX(B2:B6) is the top score. =LARGE(B2:B6,2) is the second-highest.

Type the formula yourself and get it graded instantly, no Excel needed.

SMALL returns the k-th smallest value.

=SMALL(array, k)

Argument	Required?	What it is
array	Required	The range or array to work on.
k	Required	The position: 1 for the largest or smallest, 2 for the second, and so on.

=MAX(B2:B6) is the top score. =LARGE(B2:B6,2) is the second-highest.

Type the formula yourself and get it graded instantly, no Excel needed.