+ Reply to Thread
Results 1 to 2 of 2

Count Consecutive months

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    Greece
    MS-Off Ver
    Excel 2003
    Posts
    1

    Count Consecutive months

    Hi All,

    I was wondering if there is someone who can help me out with something here.

    Ok...We have a retail shop and we want to see for each customer if he had bought at least once a month any product consecutively. To see the concept: If he had bought the product let say 2 two times in January-2014, 1 time in February-2014 and 3 times in March-2014 and nothing else after that, I want simply to show 3 (times). Of course, a customer may have bought the product at a later date, let say, 5 months after, but in this case, I will need another count again for him.

    Now, the example:

    What I have is (below I have transactional data):
    CustomID | date of purchase

    44444 | 01/01/2013
    44444 | 05/02/2013
    44444 | 16/02/2013
    44444 | 26/03/2013
    44444 | 18/05/2014
    44444 | 29/06/2014
    55555 | 05/09/2013
    55555 | 01/10/2013
    55555 | 10/10/2014
    66666 | 11/11/2012


    What I need to show (I need distinct data):

    CustomID | 1st_time_of_consecutive_purchases | 2nd_time_of_consecutive_purchases |...the list may go up to 8 times, but for simplicity purposes let see for up to 2 times.
    4444 | 3 | 2 |
    5555 | 2 | - |
    6666 | - | - |


    Any ideas how to do it in Excel?

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Count Consecutive months

    Please attach a copy of your workbook so we can test solutions on your own data. Remember to remove/replace any sensitive info before uploading.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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: 2
    Last Post: 03-19-2014, 07:26 PM
  2. Count Most Consecutive Months a name appears
    By audiofreak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2013, 02:44 PM
  3. Counting Consecutive Months with a sale
    By audiofreak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2013, 06:35 PM
  4. Replies: 2
    Last Post: 03-07-2012, 03:08 PM
  5. [SOLVED] i need to add consecutive months and keep the day the same for ea.
    By Jason in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-21-2005, 06:06 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