SMALL

Returns the nth smallest value from a list to help identify lowest or ranked numbers within a dataset.

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

index - The index specifies which smallest value to return—for example, 1 returns the smallest, 2 returns the second-smallest, and so on (Required).

list - The list of numbers to iterate through (Required).

Example

SMALL([MEASURE 1,MEASURE 2,MEASURE 3],1)

In the example below, the SMALL measure is created using the SMALL function, which returns the nth smallest value from the measures MEASURE 1, MEASURE 2 and MEASURE 3.

Applying SMALL Function