View Single Post
  #1   Report Post  
Gandaf Gandaf is offline
Junior Member
 
Posts: 2
Default 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.