SMALL function

The Excel SMALL function is used to return the k-th smallest value in a range of data. It is a useful tool when you need to find the smallest values within a set of numbers.

Syntax

SMALL(array, k)

Arguments

array:	The range of values from which you want to find the k-th smallest value.
k:	The position of the smallest value you want to retrieve from the array. It should be a positive integer.

How to Use

The SMALL function is straightforward to use. Here’s a step-by-step guide with some examples:

Step 1: Select the cell where you want the result to appear.

Step 2: Enter the SMALL function, starting with the equal sign (=).

Step 3: Replace “array” with the actual range of data from which you want to find the smallest value.

Step 4: Replace “k” with the position of the smallest value you want to retrieve.

Step 5: Close the parentheses and press Enter. The function will return the k-th smallest value from the specified range.

Examples

Example 1: Let’s say you have a list of test scores in cells A1 through A10, and you want to find the 2nd smallest score. Your formula would look like this:

This formula will return the 2nd smallest test score from the range A1:A10.

Example 2: Suppose you have a list of sales numbers in cells B1 through B20, and you want to find the 5th smallest sales figure. Your formula would be:

By following these steps and using the SMALL function, you can easily find the k-th smallest value in your data.