LARGE

LARGE(array, k)

Returns the kth largest value in a list, table or cell range.

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. See Example 4.
* 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

 AB
1=LARGE({1, 2, 3}, 1) = 3-5
2=LARGE({1, 2, 3, 0}, 1) = 3-10
3=LARGE({-2, -3, 4, 5, 6}, 1) = 6-15
4=LARGE({-2, -3, 4, 5, 6}, 1) = 6 
5=LARGE(B1:B3, 1) = -50
6=LARGE(B1:B3, 1) = -5text
7=LARGE(B1:B4, 1) = -5True
8=LARGE(B1:B5, 1) = 0False
9=LARGE(B1:B6, 1) = 0=DATE(2024, 1, 1) = 01 Jan 2024
10=LARGE(B1:B7, 1) = 0=10/0 = #DIV/0!
11=LARGE(B1:B8, 1) = 0 
12=LARGE(B1:B9, 1) = 45292 
13=LARGE(B1:B10, 1) = #DIV/0! 
14=LARGE({2, "3"}, 1) = 2 
15=LARGE({-2, TRUE}, 1) = -2 
16=LARGE({-2, FALSE}, 1) = -2 
17=LARGE({-2, "some text"}, 1) = -2 
18=LARGE({1,2,3,4,5,6},{1,2}) = {6,5} 
19=LARGE(, ) = #NUM! 
20=LARGE({1, 2, 3, 4, 5}, -1) = #NUM! 
21=LARGE({1, 2, 3, 4, "some text"}, 5) = #NUM! 
22=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.

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