# LARGE

LARGE(array, k)

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

 array The array for which you want to determine the Kth largest value. k The position from the largest to return.

 REMARKS
 * This function can return multiple values.* 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

 A B 1 =LARGE({1, 2, 3}, 1) = 3 -5 2 =LARGE({6, 4, 5}, 2) = 5 -10 3 =LARGE({1, 5, 5, 5, 8}, 2) = 5 -15 4 =LARGE({1, 5, 5, 5, 8}, 4) = 5 1 5 =LARGE({-3, -2, 0, 3, 2}, 3) = 0 text 6 =LARGE({-3, -2, 0, 3, 2}, 5) = -3 True 7 =LARGE({1, 2, "3"}, 1) = 2 False 8 =LARGE(B1:B3, 1) = -5 =DATE(2024, 1, 1) = 01 Jan 2024 9 =LARGE(B4:B5, 1) = 1 =10/0 = #DIV/0! 10 =LARGE(B1:B3, B4) = -5 11 =LARGE({1, 2, 3, 4, 5, 6}, {1, 2}) = {6, 5} 12 =LARGE(B5:B7, 1) = #NUM! 13 =LARGE(B1:B9, 1) = #DIV/0! 14 =LARGE({1, 2, 3, 4, 5}, ) = #NUM! 15 =LARGE({1, 2, 3, 4, 5}, 10) = #NUM!

 1 - What is the largest number in the values (1,2,3).2 - What is the 2nd largest number in the values (4,5,6).3 - What is the 2nd largest number in the values (1,5,5,5,8).4 - What is the 4th largest number in the values (1,5,5,5,8).5 - What is the 3rd largest number in the values (-3,-2,0,3,2).6 - What is the 5th largest number in the values (-3,-2,0,3,2).7 - What is the largest number in the values (1,2,"3").8 - What is the largest number in the range "B1:B3".9 - What is the largest number in the range "B4:B5".10 - What is the largest number in the values (1,2,3).11 - What are the top two largest numbers in the values (1,2,3,4,5,6).12 - What is the largest number in the range "B5:B7".13 - If any of the cells contain an error that error value is passed on.14 - If "k" is left blank, then #NUM! is returned.15 - If "k" > length of the "array", then #NUM! is returned.