LARGE(array, k)

Returns the kth largest value in a list or array of numbers.

arrayThe array for which you want to determine the Kth largest value.
kThe 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.office.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.

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