Syntax
=LARGE(data, n)
data- The range of numbers to look in.
n- Which rank to return: 1 is the largest, 2 the second largest, and so on.
LARGE function in Google Sheets
LARGE returns the nth largest value in a range: the second-best score, the third-highest sale, and so on. LARGE(range, 1) is the same as MAX.
Practice LARGE
Task 1 of 1
What is the second-highest score? Answer in D2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
LARGE examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Product | Units | Revenue |
| 2 | Ava | West | Monitor | 12 | $2,400.00 |
| 3 | Liam | East | Keyboard | 30 | $1,500.00 |
| 4 | Maya | West | Mouse | 45 | $900.00 |
| 5 | Noah | North | Monitor | 8 | $1,600.00 |
| 6 | Zara | East | Monitor | 15 | $3,000.00 |
| 7 | Omar | West | Keyboard | 22 | $1,100.00 |
| Formula | Result | What it shows |
|---|---|---|
=LARGE(E2:E7, 1) | $3,000.00 | Same as MAX. |
=LARGE(E2:E7, 2) | $2,400.00 | Runner-up revenue. |
=LARGE(D2:D7, 3) | 22 | Third-highest units. |
Tips and common mistakes
- Duplicates each take a rank. If the top two values are equal, LARGE(…, 2) returns the same number as LARGE(…, 1).
- If n is larger than the number of values, LARGE returns #NUM!.
- Build a top-3 list by putting 1, 2, 3 in helper cells and referencing them as n.
Related functions
Learning step by step? LARGE is covered in Lesson 31: LARGE & SMALL of the free course.