How do I find the two lowest values in a range?

Try
=SMALL(A1:A10,1)
=SMALL(A1:A10,2)
and if you want the sum
=SUM(SMALL(A1:A10,{1,2}))

but if you want the 2 lowest Unique values, the formula becomes is a little
bit more complicated. Let us know if that's the case.

Ola

Look at the MIN and SMALL functions

On Sun, 20 Feb 2005 15:49:02 -0800, dlroelike
<dlroelike@discussions.microsoft.com> wrote: