LARGE |
LARGE(array, k) |
Returns the kth largest value in a list or array of numbers. |
array | The array for which you want to determine the Kth largest value. |
k | The position from the largest to return. |
REMARKS |
* You can use this function to select a value based on its relative standing. * An alternative way to find the Kth largest value is just to sort the data into descending order. * Any text or non numerical values are ignored. * Any duplicate numbers are counted the same as values that are different. Examples 4,5,6,7,8. * If "array" is empty, then #NUM! is returned. See Example 18. * If "k" <= 0, then #NUM! is returned. See Example 20. * If "k" = 1, then the largest value is returned. * If "k" = length of the "array", then the smallest value is returned. * If "k" > length of the "array", then #NUM! is returned. Example 21. * You can use the SMALL function to return the kth smallest value in a list or array of numbers. * You can use the MAX function to return the largest value in a list of array of numbers. * You can use the MIN function to return the smallest value in a list of array of numbers. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
1 - What is the 3rd largest number in this array. 2 - What is the 4th largest number in this array. 3 - What is the 5th largest number in this array. 4 - What is the 1st largest number in this array when there are 2 duplicates. 5 - What is the 2nd largest number in this array when there are 2 duplicates. 6 - What is the 3rd largest number in this array when there are 2 duplicates. 7 - What is the 4th largest number in this array when there are 2 duplicates. 8 - What is the 5th largest number in this array when there are 2 duplicates. 18 - If "array" is empty, then #NUM! is returned. 19 - If "k" <= 0 then #NUM! is returned. 20 - If "k" > length of the "array", then #NUM! is returned. The total length of the "array" is 4 because the text entry is ignored. 21 - If "k" > length of the "array", then #NUM! is returned. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top