difference between the lowest and next lowest value
 

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?

difference between the lowest and next lowest value
 

On Sun, 14 Dec 2008 06:55:01 -0800, Narnimar
wrote:

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(A1:D1,2)-SMALL(A1:D1,1)

Hope this helps / Lars-Åke

difference between the lowest and next lowest value
 

=SMALL(A1:D1,2)-SMALL(A1:D1,1) or
=SMALL(A1:D1,2)-MIN(A1:D1)
--
David Biddulph

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

difference between the lowest and next lowest value
 

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

difference between the lowest and next lowest value
 

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



"Don Guillett" wrote:

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

difference between the lowest and next lowest value
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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



"Don Guillett" wrote:

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