Name

LARGE

Synopsis

Use LARGE to find a specific value within an array based upon its size. For example, you may want to find the second largest value in the array.

To Calculate

=LARGE(Array, K)

Both arguments are required for this function.

Array

Indicates a range of numeric values.

K

Indicates a positive numeric value that specifies the position from largest to smallest that you want to find. To find the largest value in the array you specify a 1 for the K argument. If the value specified for the K argument is a decimal, it is rounded to the closest integer.

Example

Figure 15-25 illustrates how LARGE finds the largest and second largest values in an array. To find the largest value in the array a value of 1 was specified for the K argument. To find the second largest value, the K argument had a value of 2.

Use LARGE to find a value in an array based upon how large it is compared to other values

Figure 15-25. Use LARGE to find a value in an array based upon how large it is compared to other values

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial