The LARGE function returns the k-th largest value in an array or a range of cells containing numerical values.




Argument Description
array The array or range of data for which you want to determine the k-th largest value
k The position, from the largest, in the array or cell range of data to return


  A B C D
1 Data Data    
2 12 15    
3 17 18    
4 14 27    
5 13 16    
6 5 28    
8 Formula Result Notes
9 =LARGE(A2:A6,3) 13 3rd largest number in the data set A2:A6
10 =LARGE(A2:B6,3) 18 3rd largest number in the data set A2:B6
11 =LARGE(A2:B6,8) 13 8th largest number in the data set A2:B6

Note: If n is the number of data points in a range, then LARGE(array,1) returns the largest value, and LARGE(array,n) returns the smallest value.

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if either:

  the supplied k is less than 1 or greater than the number of values in the supplied array
  the array is empty