Results 1 to 2 of 2

If a cell is not blank subtract the next cell in the same column that is not blank

Threaded View

  1. #1
    Registered User
    Join Date
    02-20-2018
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    42

    If a cell is not blank subtract the next cell in the same column that is not blank

    Hello,
    I have a column (Column A) with a formula that only returns values on certain rows otherwise it returns "". I need a formula for column B that subtacts the next value in the column skipping over the blank ("") ones.
    For example
    Column A : 5 ,"","","","",3,"","","",-2,"","","","","","",9
    Column B : 2 ,"","","","",5,"","","",-11,"","","","","","",""
    column B is what I would like to achieve where the B1 would be A1-A6, B6 would be A6-A10, and B10 would be A10-A17
    Thanks in advance.
    Last edited by Renegade115; 02-25-2019 at 06:02 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 16
    Last Post: 07-10-2018, 06:38 PM
  2. subtract value from cell if other cell is not blank
    By Chieltje in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2016, 12:46 PM
  3. Replies: 3
    Last Post: 08-20-2013, 10:39 AM
  4. [SOLVED] If Cell in column B blank then various cell are blank - vba tweek needed!!!
    By skyping in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2013, 12:24 PM
  5. Replies: 0
    Last Post: 03-05-2013, 09:22 AM
  6. Find first blank cell in column if rightmost cell is non blank
    By Mothman in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-19-2010, 02:22 AM
  7. insert a blank column if a cell is blank...how?
    By bego in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2007, 03:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1