Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
MAX vs LARGE: top value vs the nth value in Excel and Sheets
Excel & Google Sheets
=MAX(A2:A7)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Score |
| 45 |
| 80 |
| 30 |
| 95 |
| 60 |
| 75 |
=MAX(A2:A7)→95
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1MAX(A2:A7) returns the highest value — here 95.
- 2LARGE(A2:A7, 1) returns the same 95; LARGE(A2:A7, 2) returns the 2nd highest, 80.
- 3Use MAX for the top value and LARGE when you need a specific rank below the top.
Tips
- Build a top-3 list with LARGE(range,1), LARGE(range,2), LARGE(range,3).
- LARGE ignores text and blanks but errors if n is larger than the count of numbers.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
Is MAX faster than LARGE?
For the single highest value they are effectively equivalent; MAX is simpler to read. Use LARGE only when you need the nth value.