SMALL function
Numbers
The number array from which the nth smallest number is returned.
N
The position of the number to return, in a version of the given array sorted in ascending order.
Returns
The nth smallest number in the given array, where n is given as the second parameter.
Returns the nth smallest number in the given array, where n is given as the second parameter.
Examples
Returns 5, which is the second smallest number in the { 22, 5, 3, 14 }{ 22; 5; 3; 14 } array.
Returns 5, which is the second smallest number in the { 22, 5, 3, 14 }{ 22; 5; 3; 14 } array. This formula is equivalent to SMALL({ 22, 5, 3, 14 }, 2)SMALL({ 22; 5; 3; 14 }; 2). It first sorts the array in ascending order, resulting in the array { 3, 5, 14, 22 }{ 3; 5; 14; 22 }, and then selects the second element of that array.