The SMALL function returns the k’th smallest value from an array or a range of cells containing numerical values.




Argument Description
array An array or range of numerical data for which you want to determine the k-th smallest value
k The position, from the smallest, in the array or range of data to return


  A B C D
1 Data 1 Data 2    
2 12 15    
3 17 18    
4 14 27    
5 13 16    
6 5 28    
8 Formula Result Notes
9 =SMALL(A2:A6,4) 14 4th smallest number in first column
10 =SMALL(B2:B6,3) 18 3rd smallest number in second column

Usage note: Use this function to return values with a particular relative standing in a data set.

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied k is less than 1 or greater than the number of values in the supplied array
Wrong value returned Occurs if the values in the supplied array are text representations of numbers, instead of actual values