+ Reply to Thread
Results 1 to 4 of 4

Count Days, and last transaction days

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    Manchester, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post Count Days, and last transaction days

    Hello.

    I am trying to enter two formulas to a large dataset. The first counts the days the transaction was open for, and the second calculates the number of days since we last received a call from a customer.

    The data simply lists the the unique transaction reference, each date as a column with the number of calls we had on each day. The problem I am finding is that 'count' and 'count if' ignores the days in-between when we receive no calls; I need the total transaction time.

    Please help, thanks.

    Problem.xlsx

    Thanks
    Stuart
    Last edited by ssttuu; 04-03-2013 at 03:52 PM. Reason: grammar

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Count Days, and last transaction days

    Hi Stuart,

    I used array formulas... so make sure if you want to edit the formula, you need to use CTRL-SHIFT-ENTER (array enter), not just ENTER... when you use array enter, you will see a magical {} curly brackets surround your formula...

    Let me know if you have any questions. Note: some of my numbers are different from yours, but I think mine's correct... let me know otherwise...

    Dennis
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,785

    Re: Count Days, and last transaction days

    For days since last transaction use:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you want to auto adjust the dates use a defined name:
    TransactionDates
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by protonLeah; 04-03-2013 at 05:34 PM.
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    12-14-2012
    Location
    Manchester, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Count Days, and last transaction days

    Super. Thank you so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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