Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

SMALL

Returns the Nth smallest value in a dataset.

Sample Usage

SMALL(A1:B4,5)
SMALL(A1:B4,C5)

Syntax

SMALL(data, rank)

  • data - The array or range containing the dataset.
  • rank - The position (from the smallest) to return.

Examples

SMALL(A1:B4,5) returns the the 5th smallest element from A1:B4. 

 

Notes

  • Setting rank to 5 will cause SMALL to return the 5th smallest element from data.