Stat · Nov 16, 2026

The SMALL function,
measured & explained.

SMALL ranks from the bottom: SMALL(range,1) is the minimum, SMALL(range,2) the second lowest, and so on. Paired with LARGE it gives you the full spread of a data set — bottom-N reports, worst performers, and the range (max minus min). Like LARGE, k must lie between 1 and the number of numeric values or it returns #NUM!.

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

How SMALL works

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

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

SMALL for bottom-N and spread

The other end of the leaderboard. Click any row to load it.

Lowest values and the range

ExpressionResultWhy
=SMALL(A2:A8,1)45Smallest score (= MIN)
=SMALL(A2:A8,2)60Second smallest
=SMALL(A2:A8,3)78Third smallest
=SMALL(B2:B8,1)600Lowest sale
=SMALL(B2:B8,2)700Second lowest sale
=LARGE(A2:A8,1)-SMALL(A2:A8,1)47Range = max minus min
⚠ k must be 1..n. SMALL(A2:A8,0) and SMALL(A2:A8,99) both return #NUM!. SMALL(range,1) equals MIN, just as LARGE(range,1) equals MAX.
SMALL(range,1)=MIN. LARGE(range,1)-SMALL(range,1) is the statistical range. SMALL ignores text and blanks; ties repeat at consecutive ranks.
// 03 — Try it live

Interactive SMALL playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset for bottom-N values and the range.

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 SMALL works

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

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

Master stat

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

  • k=1 is MIN, k=2 second lowest
  • k must be 1..n else #NUM!
  • LARGE-SMALL = statistical range
  • 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