+ Reply to Thread
Results 1 to 3 of 3

Count only the highest timestamp value of each set of values

  1. #1
    Registered User
    Join Date
    05-13-2010
    Location
    New Brunwsick, Canada
    MS-Off Ver
    Excel 2013
    Posts
    22

    Count only the highest timestamp value of each set of values

    I have a large data file where I am counting up the number of calls users participate on.
    I only want to count a call once and only count the call for the final user on the call.

    I'd prefer to avoid VBA at this time, but my file will likely need it eventually.

    Attaching sample. Could use some guidance. Thank you in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Count only the highest timestamp value of each set of values

    Enter formula in D2 andcopy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    05-13-2010
    Location
    New Brunwsick, Canada
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Count only the highest timestamp value of each set of values

    This is one of those moments that a you drop your head into the palm of your hand when you realize you were trying to make things more complicated than they needed to be. Thank you.

+ Reply to Thread

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: 06-09-2016, 12:51 PM
  2. Count all equal highest values in a row.
    By pittsburghr2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2014, 01:19 PM
  3. Count 80 from this timestamp highlight the remainder & so on...
    By CoraHarrison in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2014, 06:22 AM
  4. Replies: 1
    Last Post: 01-10-2014, 01:55 PM
  5. Count number of cells fall within a certain timestamp
    By tmcfann in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2013, 03:04 PM
  6. Returning the Highest Count of a row of Values
    By hammer2 in forum Excel General
    Replies: 2
    Last Post: 12-06-2011, 09:25 PM
  7. How to get a count of timestamp on 1 date
    By macking in forum Excel General
    Replies: 4
    Last Post: 04-13-2011, 12:55 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