Returns the n-th lowest number in a provided range.
- range—The group of numbers to return the n-th lowest value from.
- n—A number representing the position, from the lowest, to return.
- SMALL will only look at numbers in the given range. If the range doesn’t contain numbers, you’ll receive an #INVALID VALUE or #INVALID COLUMN VALUE error.
- If the n value is higher than the total number of values in the range, you'll receive an #INVALID DATA TYPE error.
This example references the following range in a column named Supply.
Given the table above, here are some examples of using SMALL in a sheet:
|=SMALL(Supply1:Supply5,4)||Return the 4th lowest number||28|
|=SMALL(Supply1:Supply5,3)||Return the 3rd lowest number||14|
|=SMALL(Supply1:Supply5,2)||Return the 2nd lowest number||5|