difference between the lowest and next lowest value

N

Narnimar

I have data values in a1, b1 c1 and d1 say 12, 15, 14 & 11 respectively. Now
I need a formula in f1 to look up in a1:d1 and return the difference between
the lowest and next lowest value among these four values. (in this case 11 is
lowest and 12 is next to lowest, so the difference is 1)
Any method in excel?
 
L

Lars-Åke Aspelin

I have data values in a1, b1 c1 and d1 say 12, 15, 14 & 11 respectively. Now
I need a formula in f1 to look up in a1:d1 and return the difference between
the lowest and next lowest value among these four values. (in this case 11 is
lowest and 12 is next to lowest, so the difference is 1)
Any method in excel?
Click to expand...

Try this formula in cell F1:

=SMALL(A1:D1,2)-SMALL(A1:D1,1)

Hope this helps / Lars-Åke
 
D

Don Guillett

Wasn't worried. I was sure you could adapt the formula that I tested with
another range.
 

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

Difference Between Highest And Lowest? 4
Index / match combination 8
Index / Match / value in a range? 2
Find the difference between the high & low value of a given set. 3
Pick the low number in a column of Numbers 3
Problem with the 0 value 2
How do I record new Highest / Lowest numbers as data changes in ce 2
copy-pasting a cell and finding lows and highs 1

Top