Large, 264 large – Apple iWork '09 User Manual
Page 264
LARGE
The LARGE function returns the n
th
-largest value within a collection. The largest value
is ranked number 1.
LARGE(num-date-dur-set, ranking)
Â
num-date-dur-set: A collection of values. num-date-dur-set is a collection
containing number, date, or duration values. All values must be of the same type.
Â
ranking: A number representing the size ranking of the value you want to retrieve.
ranking is a number value and must be in the range of 1 to the number of values in
the collection.
Usage Notes
A ranking of 1 retrieves the largest number in the collection, 2 the second-largest,
Â
and so on. Values included in the array that are of the same size are ranked together,
but impact the outcome.
Examples
Assume the following table contains the cumulative test scores for this semester for your 20 students.
(We have organized the data this way for the example; it would likely originally have been in 20
separate rows.)
=LARGE(A1:E4, 1) returns 100, the largest cumulative test score (cell B2).
=LARGE(A1:E4, 2) returns 92, the second-largest cumulative test score (either cell B2 or cell C2).
=LARGE(A1:E4, 3) returns 92, also the third-largest cumulative test score as it appears twice (cells B2
and C2).
=LARGE(A1:E4, 6) returns 86, the sixth-largest cumulative test score (order is 100 , 92, 92, 91, 90, then 86).
Related Topics
For related functions and additional information, see:
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
264
Chapter 10
Statistical Functions