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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Narnimar" wrote in message
...
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?