Microsoft Office Tutorials and References
In Depth Information
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
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
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
Type the values from which you
want to identify the highest
number, or second highest, or
Click in the cell in which you
want the results to appear.
Click the Insert Function button.
l The Insert Function dialog box
Click here and select Statistical.
Double-click LARGE .