SMALL function
Summary
Returns the k-th smallest value in a data set
Syntax
SMALL(array, k)
The SMALL function syntax has the following arguments:
• Array Required. An array or range of numerical data for which you want to determine the k-th smallest value.
• K Required. The position (from the smallest) in the array or range of data to return.
• Array Required. An array or range of numerical data for which you want to determine the k-th smallest value.
• K Required. The position (from the smallest) in the array or range of data to return.
Example
=SMALL(A2:A10,4)
=SMALL(B2:B10,2)
=SMALL(B2:B10,2)