SMALL
Returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set.
Syntax
SMALL(array,k)
Array is an array or range of numerical data for which you want to determine the k-th smallest value.
K is the position (from the smallest) in the array or range of data to return.
Remarks
- If array is empty, SMALL returns the #NUM! error value.
- If k £ 0 or if k exceeds the number of data points, SMALL returns the #NUM! error value.
- If n is the number of data points in array, SMALL(array,1) equals the smallest value, and SMALL(array,n) equals the largest value.
Example
SMALL({3,4,5,2,3,4,5,6,4,7},4)
equals 4
SMALL({1,4,8,3,7,12,54,8,23},2)
equals 3