| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Subtraction from the lowest number postion wise in Column
Hi everyone I am making a table where I want the function to subtract using the value that is lowest excluding zero in the positional sense. compared to MAX and MIN and such. The number would just be being subtracted from an original number which would be above the list of numbers.
23-original 15 13 16 10 12 0 0 0 0 in this example I want the formula to know that it is suppose to subtract 12 from 23. So the answer I should be getting would be 11. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the lowest number in a given column | Excel Worksheet Functions | |||
| Find postion of number character within a string | Excel Programming | |||
| How can I show in a given cell a lowest number in a column? | Excel Discussion (Misc queries) | |||
| Data row wise, formula column wise | Excel Discussion (Misc queries) | |||
| How can I average certain number of lowest values in a column? | New Users to Excel | |||
Threaded Mode
