| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| determine lowest number in several columns and replace lowest numb | Excel Worksheet Functions | |||
| Difference Between Highest And Lowest? | Excel Discussion (Misc queries) | |||
| MIN to get three lowest | Excel Worksheet Functions | |||
| Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc | Excel Discussion (Misc queries) | |||
| How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions | |||
Hybrid Mode
