LARGE Function

Returns the n-th highest number in a provided range.
Sample Usage
LARGE(Cost1:Cost,3)
Syntax
LARGE(
  • range
  • n
)
  • range
    The group of numbers to return the n-th highest value from.
  • n
    A number representing the position, from the highest, to return.
Usage Notes
  • LARGE will only look at numbers in the given range. If the range doesn’t contain numbers, you’ll receive an #INVALID VALUE or #INVALID COLUMN VALUE error.
  • If the n value is higher than the total number of values in the range, you'll receive an #INVALID DATA TYPE error.
Examples

This example references the following sheet information:

 Transaction TotalUnits SoldPrice Per UnitSold Date
1$1,170.0078$15.0002/12/19 1:55 PM
2$1,491.0042$35.5002/15/19 10:23 AM
3$812.00217$200.0002/20/19 2:45 PM

Given the table above, here are some examples of using LARGE in a sheet:

FormulaDescriptionResult
=LARGE([Transaction Total]:[Transaction Total], 1)Returns the largest value in the “Transaction Total” column.$1,491.00
=LARGE([Units Sold]:[Units Sold], 2)Returns the second largest value in the “Units Sold” column.78
=LARGE([Transaction Total]:[Price Per Unit], 5)Returns the fifth largest value in the range from the “Transaction Total” column to the “Price Per Unit” column.$200.00
Was this article helpful?
YesNo