How do I use SMALL in Excel?
Use SMALL when you want to return a low-ranked value. Enter Target range, Rank in that order, then add optional arguments when needed.
Excel Function
SMALL
Returns the k-th smallest value in an array.
SMALL(array, k)Arguments
array
RequiredSpecify a reference range. You can drag or click start/end cells.
k
RequiredEnter a numeric value.
Practice Preview
Use SMALL to return the 2th smallest value in Sales in column D.
Example Table
| # | AProduct ID | BProduct Name | CCategory | DSales |
|---|---|---|---|---|
| 2 | P001 | Apple | Food | 1200 |
| 3 | P002 | Banana | Food | 980 |
| 4 | P003 | Notebook | Stationery | 450 |
| 5 | P004 | Pen | Stationery | 300 |
| 6 | P005 | Grapes | Food | 1500 |
| 7 | P006 | Ruler | Stationery | 250 |
| 8 | P007 | Peach | Food | 860 |
How to Use (Formula)
=SMALL(D2:D8, 2)Result
300
Practice This Function
SMALL FAQ
Where can I practice SMALL?
Use the "Start Function Practice" button to jump straight into SMALL drills.
What arguments does SMALL use?
The main arguments are Target range, Rank. Enter them in order.