SMALL Function

Basic Description

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

Syntax: SMALL( array, k )

where the function arguments are:

array An array of numeric values that you want to return the k’th smallest of
k The index – i.e. the function returns the k’th smallest value from the supplied array

The array argument can be supplied to the function either directly, or as a reference to a range of cells containing numeric values. If values in the supplied range of cells are text values, these values are ignored.

 

Small Function Examples

The following example shows the Excel Small function, being used to retrieve the 1st, 2nd, 3rd, 4th and 5th smallest values from the set of values in cells B3 – B8. The format of the functions are shown in the spreadsheet on the left and the resulting values are shown in the spreadsheet on the right.

 Formulas:

formula

 Results:

Result

Note that, any calls to the Small function, in which the index, k is set to 1, gives the same result as the Min function.

 

Small Function Error

If you get an error from the Excel Small Function, this is likely to be the #NUM! error occurs if the supplied k is less than 1 or greater than the number of values in the supplied array.

 

Download Documents

Download Excel File

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment