Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Functions > Statistical > LARGE
 

LARGE(array, k)

 
 Returns the Kth largest value in an 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.
     
  		• This is very similar to the SMALL function.
     
  		• Example 1 - What is the 3rd largest number in this array.
     
  		• Example 2 - What is the 4th largest number in this array.
     
  		• Example 3 - What is the 5th largest number in this array.
     
  		• Example 4 - What is the 1st largest number in this array when there are 2 duplicates.
     
  		• Example 5 - What is the 2nd largest number in this array when there are 2 duplicates.
     
  		• Example 6 - What is the 3rd largest number in this array when there are 2 duplicates.
     
  		• Example 7 - What is the 4th largest number in this array when there are 2 duplicates.
     
  		• Example 8 - What is the 5th largest number in this array when there are 2 duplicates.
     
  		• Example 9 -
     
  		• Example 10 -
     
  		• Example 11 -
     
  		• Example 12 -
     
  		• Example 13 -
     
  		• Example 14 -
     
  		• Example 15 -
     
  		• Example 16 -
     
  		• Example 17 -
     
  		• Example 18 - If "array" is empty, then #NUM! is returned.
     
  		• Example 19 - If "k" <= 0 then #NUM! is returned.
     
  		• Example 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.
     
  		• Example 21 - If "k" > length of the "array", then #NUM! is returned.

     EXAMPLES
     
     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!
    		 
     Functions - L | Index - L | Office Online 2013 | 2010 | 2007 | 2003 
     © Better Solutions Limited 04-Jun-2013Top