Microsoft Office Tutorials and References
In Depth Information
Syntax
Figure 14.2.
Figure 14.2. The
The LARGE
LARGE function in column C allows this dynamic table to be
function in column C allows this dynamic table to be
built to show the five largest values.
built to show the five largest values.
33. In the column letters above the grid, grab the line between columns A
and B. Drag to the left to make this column narrower. It should be just
wide enough to display the numbers in column A.
44. In cell C66, enter =LARGE(
=LARGE(. Use the mouse or arrow keys to highlight
the range of data. After highlighting the data, press the F4 key to add
dollar signs to the reference. This allows you to copy the reference
to the next several rows while always pointing at the same range.
55. For the second argument, point to the 1 in cell A66. Leave this referen-
ce as relative (that is, no dollar signs) so that it will change to A67,
A68, and so on when copied. The first formula in cell C66 indicates
that the largest value is 13,560.43. So far, you ve done a lot of work
just to find out the same thing that the MAX function could have told
you. However, the power comes in the next step.
Search JabSto ::




Custom Search