LARGE ranks from the top: LARGE(range,1) is the maximum, LARGE(range,2) the runner-up, and so on. It is how you build leaderboards, top-N reports and podium results without sorting the data. The only rule to respect is that k must lie between 1 and the number of numeric values; anything outside that range returns #NUM!.
Returns a number. The k-th largest value; k must be 1..n. Text and blanks in ranges are ignored.
Podium positions without sorting. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =LARGE(A2:A8,1) | 92 | Largest score (= MAX) |
| =LARGE(A2:A8,2) | 85 | Second largest |
| =LARGE(A2:A8,3) | 78 | Third largest |
| =LARGE(B2:B8,1) | 1500 | Top sale |
| =LARGE(B2:B8,2) | 1200 | Second top sale |
| =MAX(A2:A8) | 92 | MAX equals LARGE(...,1) |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to build a top-N leaderboard.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
LARGE is a core statistical function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
LARGE is one piece. The full course walks the toolkit end to end with live, measured examples.