Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > SMALL
 

SMALL(array, k)

 
 Returns the Kth smallest value in a data set. Use this function to return values with a particular relative standing in a data set.

 arrayThe array for which you want to determine the Kth smallest value.
 kThe position from the smallest in the array to return.

 REMARKS
 
  		• If "array" is empty, then #NUM! is returned.
     
  		• If "k" <= 0 , then #NUM! is returned.
     
  		• If "k" exceeds the number of data points, then #NUM! is returned.
     
  		• If "k" = 1, then the smallest value is returned.
     
  		• If "k" = length of the array, then the largest value is returned.
     
  		• This is very similar to the LARGE() function.

     EXAMPLES
     
     A
    1=SMALL({5,4,3,2,1},3) = 3
    2=SMALL({5,4,3,2,1},2) = 2
    3=SMALL({1,2,3,4,5},2) = 2
    4=SMALL({1,2},1) = 1
    5=SMALL({1,2,3,4,5,6,7,8,9},1) = 1
    6=SMALL({1,2,3,4,5,6,7,8,9},9) = 9
    7=SMALL({1,2},3) = #NUM!
    8=SMALL({""},1) = #NUM!
    		 
     Functions - S | Index - S | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top