Skip to Content

SMALL

Returns the k-th smallest value in a data set

Syntax

SMALL(array, k)

Parameters

  • array: Required. An array or range of numerical data
  • k: Required. The position (from the smallest) in the array to return

Example

=SMALL(A1:A10, 2)
Returns: NumberSince: Excel 2003