Microsoft Office Tutorials and References
In Depth Information
Syntax
Syntax
=LARGE(array,k)
The LARGE function returns the kth largest value in a data set. You can use
this function to select a value based on its relative standing. For example,
you can use LARGE to return a highest, runner-up, or third-place score. This
function takes the following arguments:
array
array This is the array or range of data for which you want to
determine the kth largest value. If arrayis empty, LARGE returns a
#NUM! error.
k This is the position (from the largest) in the array or cell range
of data to return. If kis less than or equal to 0, or if kis greater
than the number of data points, LARGE returns a #NUM! error.
Follow these steps to build a table of the five largest customer receiv-
ables:
11. Make the second argument of the function the numbers 1 through 5.
Starting from the data set shown in Figure 14.1 , insert a new column A
to hold the values 1 through 5.
22. In A66:A70, enter the numbers 1 through 5, as shown in Figure 14.2 .
Search JabSto ::




Custom Search