Excel Function : SMALL

Download now!

Excel Function : SMALL

Category

Statistical

Description

Returns the k-th smallest value in a data set

Microsoft Excel Reference Page

https://support.office.com/en-us/article/SMALL-function-17da8222-7c82-42b2-961b-14c45384df07

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.