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.