Prev: Formula from closed workbook?
Next: folder picker
From: G on 12 Apr 2010 11:28
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
From: tompl on 12 Apr 2010 12:33
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
 | 
Pages: 1
Prev: Formula from closed workbook?
Next: folder picker