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!.
Returns a number. The k-th smallest value; k must be 1..n. Text and blanks in ranges are ignored.
The other end of the leaderboard. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =SMALL(A2:A8,1) | 45 | Smallest score (= MIN) |
| =SMALL(A2:A8,2) | 60 | Second smallest |
| =SMALL(A2:A8,3) | 78 | Third smallest |
| =SMALL(B2:B8,1) | 600 | Lowest sale |
| =SMALL(B2:B8,2) | 700 | Second lowest sale |
| =LARGE(A2:A8,1)-SMALL(A2:A8,1) | 47 | Range = max minus min |
Edit the table or type any formula — the engine evaluates instantly. Load a preset for bottom-N values and the range.
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.
SMALL is a core statistical function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
SMALL is one piece. The full course walks the toolkit end to end with live, measured examples.