+ Reply to Thread
Results 1 to 4 of 4

Count Duplicate Occurances, by date range and single date

  1. #1
    Forum Contributor Pierce Quality's Avatar
    Join Date
    07-29-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    221

    Count Duplicate Occurances, by date range and single date

    Hi All,

    Im having a little trouble with counting job numbers by a single date. The current formula I am using works great when I want to count job numbers that dont appear on more then one date, but if the job number appears on more then one date I will get inaccurate data because the value on the formula will only appear on the first instance of the job number.

    In the attached example, Job 3 appears on both 1-Oct and 2-Oct. When I got to my Pivot Slicers I filter by date, then Job Number. If I select all dates Job 3 will appear, but if I select 2-Oct the Job will not appear because the formulas have already counted it on 1-Oct.

    Do I need to add an additional column with a formula to count the Job number respstive to each date, or am I just structuring this incorrectly? Im attempting to keep this as simple as possible because there is a massive amount of formulas in the actual workbook and I want to keep it functioning as fast as possible.

    Thanks!
    Attached Files Attached Files
    Last edited by Pierce Quality; 11-18-2013 at 03:05 PM.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Count Duplicate Occurances, by date range and single date

    May be this......

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor Pierce Quality's Avatar
    Join Date
    07-29-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Count Duplicate Occurances, by date range and single date

    Quote Originally Posted by sktneer View Post
    May be this......

    Please Login or Register  to view this content.
    Hello sktneer, thanks for the reply!

    This formula works very well to count the occurance of the job number per day, thank you!

    If I apply this formula as an additional column it will add another 40K rows of calculations to my sheet, do you have any additional insight for me to be able to search by a single date or a date range in the pivot table?

    Thanks!

  4. #4
    Forum Contributor Pierce Quality's Avatar
    Join Date
    07-29-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Count Duplicate Occurances, by date range and single date

    I ended up testing this on a couple thousand rows of data and it didnt seem to add too much time, my sheet ended up with 220K calculations per sheet, which seems to be manageable so far.
    Marking this as solved, thanks!

+ 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. [SOLVED] count date occurances in range of dates...
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 06:05 PM
  2. [SOLVED] count date occurances in range of dates...
    By Alex in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  3. count date occurances in range of dates...
    By Alex in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. count date occurances in range of dates...
    By Alex in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] count date occurances in range of dates...
    By Alex in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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