Stat · Nov 16, 2026

The LARGE function,
measured & explained.

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!.

D1
fx
=LARGE(…)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How LARGE works

Returns a number. The k-th largest value; k must be 1..n. Text and blanks in ranges are ignored.

=LARGE(array, k)
arrayThe range or array of numbers to rank.
kThe position from the largest (1 = maximum).
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Rank from the top

LARGE for top-N reports

Podium positions without sorting. Click any row to load it.

Building a leaderboard

ExpressionResultWhy
=LARGE(A2:A8,1)92Largest score (= MAX)
=LARGE(A2:A8,2)85Second largest
=LARGE(A2:A8,3)78Third largest
=LARGE(B2:B8,1)1500Top sale
=LARGE(B2:B8,2)1200Second top sale
=MAX(A2:A8)92MAX equals LARGE(...,1)
⚠ k must be 1..n. LARGE(A2:A8,0) and LARGE(A2:A8,99) both return #NUM! because there are only five numbers. Ties repeat the same value at consecutive ranks.
LARGE(range,1)=MAX. LARGE ignores text and blanks. With ties, the same value can occupy several consecutive k positions.
// 03 — Try it live

Interactive LARGE playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to build a top-N leaderboard.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

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.

// 05 — Cross-platform

Where LARGE works

LARGE is a core statistical function present in every Excel version and platform.

PlatformSupportNotesGotcha
✓ Supported full LARGE◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master stat

LARGE is one piece. The full course walks the toolkit end to end with live, measured examples.

  • k=1 is MAX, k=2 runner-up
  • k must be 1..n else #NUM!
  • Ties repeat at consecutive ranks
  • Ignores text and blanks
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked