SMALL

SMALL(array, k)

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

arrayThe array for which you want to determine the Kth smallest value.
kThe 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({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!


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top