Results 1 to 11 of 11

Return today's value - data source pushes daily cumulative total!

Threaded View

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Colchester, England
    MS-Off Ver
    Excel 2007
    Posts
    21

    Return today's value - data source pushes daily cumulative total!

    Hi all

    I have a tricky situation that has stumped me.

    XXXX

    'Campaign Stats' = data pushed from DotDigital email marketing platform, appending a row for each day of activity for each campaign. The final column is a 'Lookup' for Vlookups. Please don't manipulate the data in this sheet
    'DD Daily' = This is the sheet we're working on
    'DD Running' = This simply shows us the data in 'Campaign Stats' resorted to match the order in 'DD Daily'

    The objective - As you can see, the data from DotDigital is provided as a cumulative campaign total for each day (note that the first day for each campaign will be a much bigger increment than following days, that is expected). What we actually want is the total for each individual day's activity. You can see in columns F to H that I've got tried If but realised that this will only substract the proceeding day - what we actually want to do is substract the earliest day if the row is not itself the earlier day for that campaign. I suspect MIN might be part of the answer, but I can't figure out how.

    A solution would be fantastic!!!!
    Last edited by Tacalabala; 08-16-2021 at 10:36 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return A cumulative Percentage value based on Today's date referencing a start and end dat
    By AbdulkareemAlhassni in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-16-2018, 05:49 PM
  2. [SOLVED] Array formula to return all steps of cumulative / running total
    By Stormin' in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-03-2018, 05:18 AM
  3. Formula for calculating daily total pay when Cumulative hours go over 40
    By dasboot71 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2017, 07:50 AM
  4. Formula for calculating daily total pay when Cumulative hours go over 40
    By dasboot71 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2017, 02:10 AM
  5. [SOLVED] Converting daily data into weekly and making the weekly number a cumulative return
    By Duchess1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-28-2015, 10:23 AM
  6. Replies: 4
    Last Post: 09-05-2012, 05:25 AM
  7. Adding daily run hours to cumulative total hours
    By Rodstew in forum Excel General
    Replies: 8
    Last Post: 08-08-2012, 07:10 PM

Tags for this Thread

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