Excel Function : SMALL

Download now!

Excel Function : SMALL




Returns the k-th smallest value in a data set

Microsoft Excel Reference Page


Syntax and Description of the SMALL Excel Function

The syntax for the SMALL function in Microsoft Excel is: =SMALL(array, k) where array is the range of cells to consider and k is the nth smallest value that you want to return.

About SMALL Excel Function

The SMALL function returns the k-th smallest value in a data set, where k is a number between 1 and 1,048,576.