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
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