Small Function

Question:            Is there an alternative to the minimum function when finding the smallest value in a given data range?

Answer:               Yes, the Small function

Why:                Returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set



Array     is an array or range of numerical data for which you want to determine the k-th smallest value.

    is the position (from the smallest) in the array or range of data to return.

Applies To:         Excel 2003, 2007 and 2010

  1. Refer to the following screen shot used for this example

2.  Select cell B19 and type =Small(B2:B17,1)

3.  The answer will be $29.20 meaning the sales person with the lowest sales value is Anderson .P.

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.


Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations