SMALL

The SMALL function returns the nth smallest number from a list of values by identifying the value at the specified rank when the numbers are arranged from lowest to highest. It is useful for finding bottom or ranked values within a dataset.

Syntax

SMALL(list, index)

Arguments

• list: The list of numbers to evaluate.
• index: The position of the value to return when the numbers are sorted in ascending order. For example, 1 returns the smallest value, 2 returns the second-smallest value, and so on.

Return value

Returns the nth smallest value from the specified list.

Example

SMALL([2025.Q1.Actuals, 2025.Q2.Actuals, 2025.Q3.Actuals, 2025.Q4.Actuals], 1)

In this example, the Least Actuals measure is created using the SMALL function, which returns the smallest value from the quarterly Actuals values of 2025.

Excel equivalent

SMALL