Results 1 to 22 of 22

Calcuate difference in one column based on value change in another column

Threaded View

  1. #1
    Registered User
    Join Date
    08-25-2016
    Location
    USA
    MS-Off Ver
    14.0.7172.5000 (32-bit)
    Posts
    96

    Calcuate difference in one column based on value change in another column

    Hi all,

    Please see the attached screenshot. I want to calculate
    the difference in column U cells when the column V value
    changes from 1 to 0 and back again.

    So in this example, W26 should show the difference
    between U26 and U4 since rows 26 and 4 are the
    rows where the V value changed from 1 to 0 and
    from 0 to 1, respectively.

    Thanks for your help!
    Mark
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 12-16-2015, 05:56 PM
  2. [SOLVED] Need a formula to change cell in column 2 based off of text in column 1
    By bevwalker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-30-2014, 03:26 PM
  3. Need a formula to calcuate percentage difference between budget $ and actual $
    By meekinslfm in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-06-2014, 09:54 AM
  4. [SOLVED] How to pick name from column based value difference in column B
    By genetist in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-13-2013, 01:34 AM
  5. Change colour in column C based on Column B - future dates
    By kfwiss in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2013, 05:47 AM
  6. Based on Years calcuate Min() and Max() values from another column
    By SunOffice in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-30-2013, 11:14 AM
  7. Replies: 4
    Last Post: 09-05-2012, 01:50 PM

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