How to Find Lowest 3 Values in Excel (With Example)

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:

Excel find lowest 3 values

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.

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