O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

LARGE()

Syntax. LARGE(array,k)

Definition. This function returns the largest k-value in a data set. Use this function to select a value based on its relative size. For example, you can use LARGE() to calculate the top three sales in a table.

Arguments

  • array (required). The array or range of data for which you want to determine the largest k-value

  • k (required). The position of the element in the array or cell range to return

Background. The MIN() and MAX() functions find the smallest or largest value in a cell range, but if you need the second-largest or third-smallest value, use the LARGE() and SMALL() functions.

LARGE() returns the largest values, and SMALL() returns the smallest values from a range.

Note the following:

  • If array is empty, LARGE() returns ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required