Microsoft Office Tutorials and References
In Depth Information
Determine the
NTH LARGEST VALUE
Sometimes you want to identify and characterize
the top values in a series, such as the RBIs of the
top three hitters in Major League Baseball or the
purchases, in a given period, for your five largest
purchasers.
The LARGE function evaluates a series of numbers
and determines the highest value, second highest, or
Nth highest in the series, with N being a value’s rank
order. LARGE takes two arguments: the range of cells
you want to evaluate and the rank order of the value
you are seeking, with 1 being the highest, 2 the next
highest, and so on. The result of LARGE is the value
you requested.
Another way to determine the first, second, or Nth
number in a series is to sort the numbers from
biggest to smallest and then simply read the results,
as shown in Chapter 4. Sorting is less useful when
you have a long list or when you want to use the
result in another function, such as summing the top
five values.
1
Type the values from which you
want to identify the highest
number, or second highest, or
other value.
3
2
Click in the cell in which you
want the results to appear.
3
Click the Insert Function button.
1
2
l The Insert Function dialog box
appears.
4