SMALL

SMALL(array, k)

Returns the kth smallest numerical value.

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 AGGREGATE function to exclude hidden cells.
* 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 numerical value.
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=SMALL({1, 2, 3}, 1) = 1	-5
2	=SMALL({6, 4, 5}, 2) = 5	-10
3	=SMALL({1, 5, 5, 5, 8}, 2) = 5	-15
4	=SMALL({1, 5, 5, 5, 8}, 4) = 5	1
5	=SMALL({-3, -2, 0, 3, 2}, 3) = 0	text
6	=SMALL({-3, -2, 0, 3, 2}, 5) = 3	True
7	=SMALL({1, 2, "3"}, 1) = 1	False
8	=SMALL(B1:B3, 1) = -15	01 Jan 2025
9	=SMALL(B4:B5, 1) = 1	=10/0 = #DIV/0!
10	=SMALL(B1:B3, B4) = -15
11	=SMALL({1, 2, 3, 4, 5, 6}, {1, 2}) = {1, 2}
12	=SMALL(B5:B7, 1) = #NUM!
13	=SMALL(B1:B9, 1) = #DIV/0!
14	=SMALL({1, 2, 3, 4, 5}, ) = #NUM!
15	=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.