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.
