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 |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top