difference between the lowest and next lowest value

[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?

 

[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?

Try this formula in cell F1:

=SMALL(A11,2)-SMALL(A11,1)

Hope this helps / Lars-Åke

 

[David Biddulph]

=SMALL(A11,2)-SMALL(A11,1) or
=SMALL(A11,2)-MIN(A11)

 

[Don Guillett]

=SMALL(J8:M8,2)-SMALL(J8:M8,1)

 

[Narnimar]

Don Guillett,
The data values in a1, b1 c1 and d1. Dont worry I got the solution.

 

[Don Guillett]

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