### 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

 A 1 =LARGE({1,2,3,4,5},3) = 3 2 =LARGE({1,2,3,4,5},4) = 2 3 =LARGE({1,2,3,4,5},5) = 1 4 =LARGE({1,3,5,5,5},1) = 5 5 =LARGE({1,3,5,5,5},2) = 5 6 =LARGE({1,3,5,5,5},3) = 5 7 =LARGE({1,3,5,5,5},4) = 3 8 =LARGE({1,3,5,5,5},5) = 1 9 =LARGE({1,2,3,4,5,6,7,8,9},1) = 9 10 =LARGE({1,2,3,4,5,6,7,8,9},9) = 1 11 =LARGE({1,2,3,4,"some text"},3) = 2 12 =LARGE({10,30,60,90},3) = 30 13 =LARGE({10,30,60,90},3) = 30 14 =LARGE({1,2,3,4,5},5) = 1 15 =LARGE({1,2,"some text",3,4},3) = 2 16 =LARGE({1,2,3,4},1)+LARGE({1,2,3,4},2) = 7 17 =LARGE({1,2,3,4,5,6},{1,2}) = {6,5} 18 =LARGE(,) = #NUM! 19 =LARGE({1,2,3,4,5},-1) = #NUM! 20 =LARGE({1,2,3,4,"some text"},5) = #NUM! 21 =LARGE({1,2,3,4,5},10) = #NUM!

 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.