You can use the following formula in Excel to find the lowest 3 values in a particular range:

=TRANSPOSE(SMALL(B2:B13, {1,2,3}))

This particular formula will return an array with the lowest 3 values from the range **B2:B13**.

The following example shows how to use this formula in practice.

**Example: Find Lowest 3 Values in Excel**

Suppose we have the following dataset in Excel that shows the points scored by various basketball players:

Now suppose that we would like to find the lowest 3 values in the **Points** column.

We can type the following formula into cell **D2** to do so:

=TRANSPOSE(SMALL(B2:B13, {1,2,3}))

The following screenshot shows how to use this formula:

From the output we can see that the lowest 3 points values are **11**, **12** and **15**.

We can manually verify that these three values are indeed the lowest in the **Points** column:

Also note that we could return these three values horizontally by dropping the **TRANSPOSE** function from the formula:

=SMALL(B2:B13, {1,2,3})

The following screenshot shows how to use this formula in practice:

The formula now returns the lowest 3 values from the **Points** column horizontally instead of vertically.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Use SMALL IF Function in Excel

How to Use LARGE IF Function in Excel

How to Use a Median IF Function in Excel

How to Use a Percentile IF Function in Excel