ExcelBanter - Get 2 Lowest Numbers from 4 Cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Get 2 Lowest Numbers from 4 Cells? (https://www.excelbanter.com/excel-programming/441569-get-2-lowest-numbers-4-cells.html)

Get 2 Lowest Numbers from 4 Cells?

I want to get the 2 lowest numbers from 4 cells. Is there an easy way to
code this?

Thanks, in advance, for your help.

G

TomPl

Get 2 Lowest Numbers from 4 Cells?

Use two formulas similar to these:

=SMALL(B5:B8,1)
=SMALL(B5:B8,2)

Tom

"G" wrote:

I want to get the 2 lowest numbers from 4 cells. Is there an easy way to
code this?

Thanks, in advance, for your help.

G

All times are GMT +1. The time now is 12:05 AM.