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 Total | Units Sold | Price Per Unit | Sold Date | |
|---|---|---|---|---|
| 1 | $1,170.00 | 78 | $15.00 | 02/12/19 1:55 PM |
| 2 | $1,491.00 | 42 | $35.50 | 02/15/19 10:23 AM |
| 3 | $812.00 | 217 | $200.00 | 02/20/19 2:45 PM |
Given the table above, here are some examples of using LARGE in a sheet:
| Formula | Description | Result |
|---|---|---|
| =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 |