difference between the lowest and next lowest value

  • Thread starter Thread starter Narnimar
  • Start date Start date
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?
 
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
 
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

Find the lowest number? 3
How to bold lowest value 2
How to highlight the lowest valued cell in a column in Excel 2003 2
Index / match combination 8
Index / Match / value in a range? 2
compare 2 columns and select the lowest 2
Difference Between Highest And Lowest? 4
Highlight the lowest number - only if it does not equal another va 6

Back
Top