Excel Function

SMALL

Returns the k-th smallest value in an array.

SMALL(array, k)

Arguments

array

Required

Specify a reference range. You can drag or click start/end cells.

k

Required

Enter a numeric value.

Practice Preview

summarize sales data. Use SMALL to Returns the k-th smallest value in an array. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. use 2 for k. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=SMALL(B2:B8, 2)

Practice This Function

Practice in Sequential ModeBack to Function List