### SMALL(array, k)

Returns the kth smallest value in a list or array of numbers.

 array The array for which you want to determine the Kth smallest value. k The position from the smallest to return.

#### Remarks

 * You can use this function to select a value based on its relative standing.* An alternative way to find the Kth smallest value is just to sort the data into ascending order.* Any text or non numerical values are ignored.* If "array" is empty, then #NUM! is returned.* If "k" <= 0 , then #NUM! is returned.* If "k" = 1, then the smallest value is returned.* If "k" = length of the array, then the largest value is returned.* If "k" > length of the "array", then #NUM! is returned.* You can use the LARGE function to return the kth largest value in a list or array of numbers.* You can use the MAX function to return the largest value in a list or array of numbers.* You can use the MIN function to return the smallest value in a list or array of numbers.* For the Microsoft documentation refer to support.microsoft.com

 A 1 =SMALL({5,4,3,2,1},3) = 3 2 =SMALL({5,4,3,2,1},2) = 2 3 =SMALL({1,2,3,4,5},2) = 2 4 =SMALL({1,2},1) = 1 5 =SMALL({1,2,3,4,5,6,7,8,9},1) = 1 6 =SMALL({1,2,3,4,5,6,7,8,9},9) = 9 7 =SMALL({1,2},3) = #NUM! 8 =SMALL({""},1) = #NUM!