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

	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.