Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft 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 Nth largest value is just to sort the data into descending order.
     
  		• Any text or non numerical values are ignored.
     
  		• If "array" is empty, then #NUM! is returned.
     
  		• If "k" = 1, then the largest value is returned.
     
  		• If "k" = length of the array, then the smallest value is returned.
     
  		• If "k" <= 0, then #NUM! is returned.
     
  		• If "k" > length of the array, then #NUM! is returned.
     
  		• This is very similar to the SMALL() function.

     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,2,3,4,5,6,7,8,9},1) = 9
    5=LARGE({1,2,3,4,5,6,7,8,9},9) = 1
    6=LARGE({1,2,3,4,"some text"},3) = 2
    7=LARGE({10,30,60,90},3) = 30
    8=LARGE({10,30,60,90},3) = 30
    9=LARGE({1,2,3,4,5},5) = 1
    10=LARGE({1,2,"some text",3,4},3) = 2
    11=LARGE({1,2,3,4},1)+LARGE({1,2,3,4},2) = 7
    12=LARGE({1,2,3,4,5,6},{1,2}) = {6,5}
    13=LARGE(,) = #NUM!
    14=LARGE({1,2,3,4,"some text"},5) = #NUM!
    15=LARGE({1,2,3,4,5},-1) = #NUM!
    16=LARGE({1,2,3,4,5},10) = #NUM!
    		 
     Functions - L | Index - L | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top