Posts
MS Excel : Determine the NTH LARGEST VALUE
Sometimes you want to identify and characterize
the highest values in a series, such as the RBI of
the three best hitters in Major League Baseball or the
purchases, in a given period, for its five major
shoppers
The BIG function evaluates a series of numbers
and determine the highest value, the second highest or
Nth highest place in the series, where N is the range of a value
order. LARGE takes two arguments: the range of cells
you want to evaluate and the order of classification of the value
are you looking for, being 1 the highest, 2 the next
higher, 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 order the numbers of
from highest to lowest and then just read the results,
as shown in Chapter 4. Ordering is less useful when
have a long list or when you want to use the
result in another function, such as adding the top
Five values
1 Enter the values from which
want to identify the highest
number, or the second highest, or
other value
2 Click on the cell in which
He wants the results to appear.
3 Click the Insert Function button.
l The Insert Function dialog box
appears.
4 Click here and select Statistics.
5 Double-click BIG.
l The arguments of the function
a dialog box appears for
The great function
6 Click and drag to select
the cells you want
evaluate or write the
distance.
7 Enter a number
indicating who you are
looking for: 1 for the tallest, 2
for the second highest, 3 for
third highest, and so on.
8 Click OK.
l The cell shows the value you requested.
If K in Step 7 is greater than the number
of cells, a #NUM error appears in the cell
instead.
Apply it!
To add the first three or other higher values in aseries, you can use BIG three times in one formula:
= BIG (Sales, 3) + BIG (Sales, 2) +
BIG (Sales, 1), with Sales being the name
range of sales values.
Did you know
Other useful functions work similarly toThe great function SMALL evaluates a range of
values and returns a number. For example, if you
enter 1 as the K value, return the lowest number,
2 for the next lowest, and so on. MIN and MAX
the functions return the lowest and highest values in a
series, respectively. They take an argument: a range
of cell values.
