Results 1 to 5 of 5

Count Consecutive & Non consecutive days per given logic

Threaded View

  1. #1
    Registered User
    Join Date
    02-17-2017
    Location
    Bangkok
    MS-Off Ver
    2010
    Posts
    3

    Count Consecutive & Non consecutive days per given logic

    Hi experts,

    Need a formula to count the instances as per the data given in the attached file.

    Logic is as follows:
    1) Need to count the instances based on plant + Identifier.
    2) If days are not consecutive then count them as per actual (e.g Cell C5)
    3) If days are consecutive up to 4 days, count them as one instance (e.g C6:C7 OR C8:C10)
    4) If 5 or more days are consecutive, count them as per actual (e.g C14:C18 OR C23:C28)
    5) Populate the count next to Plant + Identifier in column O.

    P.S. For counting manually I have used pivot to aggregate my data at Plant & Identifier and populated dates next to it but if there could be a way to directly count from the "data" sheet without having to create a pivot it will be best. Be careful though that on a single day per Plant+Identifer there could be more than 1 order (column A in data sheet).

    Thanks a lot
    Attached Files Attached Files
    Last edited by asimraza89; 10-26-2019 at 09:59 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to count number of consecutive days
    By dobracik in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-05-2016, 03:10 PM
  2. Need formula to count consecutive days
    By emp2013 in forum Excel General
    Replies: 0
    Last Post: 06-27-2016, 01:57 PM
  3. Replies: 17
    Last Post: 08-03-2015, 06:15 AM
  4. Count Consecutive Days (with rule associated)
    By DUNC78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2015, 10:18 AM
  5. [SOLVED] Count number of consecutive days and instances
    By Cortlyn in forum Excel General
    Replies: 7
    Last Post: 02-06-2015, 06:02 PM
  6. [SOLVED] How to count 10 consecutive week days
    By rjassal82 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-16-2013, 05:40 AM
  7. count consecutive negative days
    By pault22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2010, 08:10 AM

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