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 range in a column named Supply.
| Supply 5 433 2 28 14 |
Given the table above, here are some examples of using LARGE in a sheet:
| Formula | Description | Result |
|---|---|---|
| =LARGE(Supply1:Supply5,4) | Return the 4th highest number | 5 |
| =LARGE(Supply1:Supply5,3) | Return the 3rd highest number | 14 |
| =LARGE(Supply1:Supply5,2) | Return the 2nd highest number | 28 |