LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
see the cells the formula relates to by double clicking the cell pvagolfer Excel Discussion (Misc queries) 1 May 16th 05 12:25 AM
trying to create an (almost) circular formula between cells and data validated cells with lists KR Excel Worksheet Functions 0 May 12th 05 07:21 PM
Macro or Formula to remove Text from Cells smck Excel Worksheet Functions 6 May 11th 05 03:22 AM
How do i select different cells to be use in a formula. Manuel Excel Discussion (Misc queries) 1 January 13th 05 03:52 PM
How do I set up a formula to repat 5 consecutive cells in a colum. jbsand1001 Excel Worksheet Functions 2 January 7th 05 08:36 PM


All times are GMT +1. The time now is 02:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"