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 (=).

1 |
=SMALL(array, k) |

**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:

1 |
=SMALL(A1:A10, 2) |

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:

1 |
=SMALL(B1:B20, 5) |

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