+ Reply to Thread
Results 1 to 8 of 8

Formula to Count Unique Customer by Month

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    4

    Formula to Count Unique Customer by Month

    Hello,

    I am trying to get to a new client count by month. So I have two columns (Customer ID and Customer Start Date) with duplicate records. Thank you so much in advance!

    Data Provided
    Customer ID (Column A)
    1) 24
    2) 24
    3) 24
    4) 24
    5) 28
    6) 28
    7) 30

    Month (Column B)
    1) 11/1/2009
    2) 11/1/2009
    3) 11/1/2009
    4) 12/1/2009
    5) 11/1/2009
    6) 12/1/2009
    7) 12/1/2009

    Answers
    - 2 new clients in 11/1/2009 (customer 24 and 28)
    - 1 new client in 12/1/2009 (customer 30)

  2. #2
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Formula to Count Unique Customer by Month

    Hello B - welcome to the forum.

    Does the attached do what you need?

    Cheers
    <-- If you're happy & you know it...click the star.:-)

  3. #3
    Registered User
    Join Date
    12-17-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Formula to Count Unique Customer by Month

    Hi Amit,

    I have always found the content on this site very helpful - so thank you for that.

    So your file does logically work. However, I am working with a huge data set thus it would be to tedious to flag each unique customer ID.

    Best,
    Bryan

  4. #4
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: Formula to Count Unique Customer by Month

    I have included a PivotTable with the summary.
    Click on the star if you think I helped you

  5. #5
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Formula to Count Unique Customer by Month

    Bryan,

    perhaps the Pivot Table is a more elegant solution.

    The attached sheet does away with the helper columns. Please note that the formula in E3 is different from E4 and below.

    Cheers

  6. #6
    Registered User
    Join Date
    12-17-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Formula to Count Unique Customer by Month

    Thank you for all the responses! Amit this version is what I was looking for thank you so much.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,899

    Re: Formula to Count Unique Customer by Month

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  8. #8
    Registered User
    Join Date
    12-17-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Formula to Count Unique Customer by Month

    Thank you for letting me know.

+ 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. SUM Sales by Month and Customer
    By gblass1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2013, 03:30 AM
  2. Count unique for specific month
    By Bob@Sun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2011, 02:52 PM
  3. Count unique days within month
    By jirib in forum Excel General
    Replies: 7
    Last Post: 08-26-2010, 06:12 PM
  4. product sum per month per customer
    By Pete Petersen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2005, 01: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