MS Excel: Small Function
In Excel, the Small function returns the nth smallest value from a set of values.
The syntax for the Small function is:
Small( array, nth_position )
array is a range or array from which you want to return the nth smallest value.
nth_position is the position from the smallest to return.
Note:
If nth_position is larger than the number of values in array, the Large function will return the #NUM! error.
If array is empty, the Large function will return the #NUM! error.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Small(A1:A5, 1) would return -2.3 =Small(A1:A5, 2) would return 4 =Small(A1:A5, 3) would return 5.7 =Small(A1:A5, 4) would return 8 =Small(A1:A5, 5) would return 32 =Small({6, 23, 5, 2.3}, 2) would return 5