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.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
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.