# 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: 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.