SMALL Function

Returns the n-th lowest number in a provided range.
Sample Usage
SMALL(Supply1:Supply5,3)
Syntax
SMALL(
  • range
  • n
)
  • range
    The group of numbers to return the n-th lowest value from.
  • n
    A number representing the position, from the lowest, to return.
Usage Notes
  • 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.
Examples

This example references the following range in a column named Supply.

Supply
5
433
2
28
14

 

Given the table above, here are some examples of using SMALL in a sheet:

FormulaDescriptionResult
=SMALL(Supply1:Supply5,4)Return the 4th lowest number28
=SMALL(Supply1:Supply5,3)Return the 3rd lowest number14
=SMALL(Supply1:Supply5,2)Return the 2nd lowest number5

 

Was this article helpful?
YesNo