SMALL
Finds the nth smallest value.
How it’s written
SMALL(range, n)Example
| A | B | |
|---|---|---|
| 1 | Name | Score |
| 2 | Amara | 72 |
| 3 | Ben | 90 |
| 4 | Chloe | 65 |
| 5 | Dev | 90 |
| 6 | Elena | 83 |
=SMALL(B2:B6,2)Result: 72
Finds the second lowest score.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
SMALL(range, 1) gives the same answer as MIN.
Practice it properly
Top performers and rankings gives you real tasks, with your formulas tested on data you haven’t seen.