Manuals/calci/LARGE

From ZCubes Wiki
Jump to navigation Jump to search
LARGE(Array,k)


  • is the array of numbers.
  • is the position of the largest number.


Description

  • This function gives the -th largest value in the given set of numbers.
  • This function can be used to find data based on relative size - such as the fourth largest number in a given list of data.
  • In , is the array of data to find the -largest value. is the position from the largest to return.
  • If is the number of data points in a range, then gives the largest value, and gives the smallest value.
  • The function gives the result as error when
       1. The array is empty.
       2.  or  is greater than the total number of points in the given set.

Examples

Spreadsheet
A B C D E
1 13 10 9 13 21
2 28 15 10 16 19
3 12 19 -1 0 18
  1. =LARGE(A1:E2,3) = 19
  2. =LARGE(A1:E2,9) = 10
  3. =LARGE(A2:E3,10) = -1
  4. =LARGE(A2:E3,9) = 0

Related Videos

LARGE


See Also

References