| 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? |
| 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 | |||
Threaded Mode
