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

O

Ola

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to subtract the two lowest values from a row of numbers 4
Combining two formulas 0
find two (2) lowest values in a range (Excel) 3
Sum A Range only if no text is present in the range 3
How do I find minimum duplicated values in a range? 2
"Drop the lowest" in computing average 8
How do I compare values of two cells and display the lowest. 2
How do I use countif like sumif ie (range,criteria,count_range) 1

Top