# SMALL

SMALL(array, k)

Returns the kth smallest value in a list, table or cell range.

 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 in 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* For the Google documentation refer to support.google.com

 A 1 =SMALL({6, 4, 5}, 2) = 5 2 =SMALL({1, 5, 5, 5, 8}, 2) = 5 3 =SMALL({1, 5, 5, 5, 8}, 4) = 5 4 =SMALL({-3, -2, 0, 3, 2}, 3) = 0 5 =SMALL({-3, -2, 0, 3, 2}, 5) = 3 6 =SMALL({1, 2, "3"}, 1) = 1 7 =SMALL(B0:B2, 1) = -15 8 =SMALL(B3:B4, 1) = 1 9 =SMALL(B0:B2, B3) = -15 10 =SMALL({1, 2, 3, 4, 5, 6}, {1, 2}) = {1, 2} 11 =SMALL(B4:B6, 1) = #NUM! 12 =SMALL(B0:B8, 1) = #DIV/0! 13 =SMALL({1, 2, 3, 4, 5}, ) = #NUM! 14 =SMALL({1, 2, 3, 4, 5}, 10) = #NUM!

 1 - What is the smallest number in the values (1,2,3).2 - What is the 2nd smallest number in the values (4,5,6).3 - What is the 2nd smallest number in the values (1,5,5,5,8).4 - What is the 4th smallest number in the values (1,5,5,5,8).5 - What is the 3rd smallest number in the values (-3,-2,0,3,2).6 - What is the 5th smallest number in the values (-3,-2,0,3,2).7 - What is the smallest number in the values (1,2,"3").8 - What is the smallest number in the range "B1:B3".9 - What is the smallest number in the range "B4:B5".10 - What is the smallest number in the values (1,2,3).11 - What are the top two smallest numbers in the values (1,2,3,4,5,6).12 - What is the smallest number in the range "B5:B7".13 - If any of the cells contain an error that error value is passed on.14 - If "k" is left blank, then #NUM! is returned.15 - If "k" > length of the "array", then #NUM! is returned.