View Single Post
  #1   Report Post  
 
Posts: n/a
Default Subtraction formula for consecutive cells in a column, skipping blanks

Column with Formulas (results of differences)
6 Blank
8 2
4 -4
Blank Blank
2 -2
19 17
2 -17
Blank Blank
Blank Blank
4 2

I want a separate column (the right column) that has a standard formula
that can go along side the left column that represents the differences
between consecutive cells in this left vertical column. It should have
the results noted on the right column. Do you know what formula that I
could use as a standard, filled down through the second column that
would get these variance results?

Thank you,

Dave