+ Reply to Thread
Results 1 to 9 of 9

Formula to show repeat customers

  1. #1
    Forum Contributor
    Join Date
    07-14-2014
    Location
    New City, NY
    MS-Off Ver
    2016
    Posts
    181

    Formula to show repeat customers

    Hello,

    I have this list with a unique customer identifier value, I am trying to show customers who ordered more than once across months and years. Can someone please help? Thanks!
    Attached Files Attached Files

  2. #2
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Formula to show repeat customers

    Hi

    Is the data sheet where you want to search and the summary sheet the end result of what you want to see from this?
    A great big thank you to all the experts on the forum that are always so friendly and helpful.

    You guys Rock!!!!

  3. #3
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Formula to show repeat customers

    See attached....

    Is this what you are looking for?
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    07-14-2014
    Location
    New City, NY
    MS-Off Ver
    2016
    Posts
    181

    Re: Formula to show repeat customers

    Thank you Andreas. What I am trying to do is to show how many customers from the list ordered more than once. I know we can do a count of the customers in a pivot. Is there a way to show it by month and year? In other words - customer X ordered 1 unit in January then in February of 2019 and then this customer ordered 2 units in 2020 or if Customer X only ordered once in 2019 and did not order after that. I wanted to see how best to illustrate this or filter out non repeat customers rather quickly.
    Appreciate your help with this.

  5. #5
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Formula to show repeat customers

    Here is another view, but ANDREAAS option is pretty close.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    07-14-2014
    Location
    New City, NY
    MS-Off Ver
    2016
    Posts
    181

    Re: Formula to show repeat customers

    Thank you for your response. Is there a formula we can use to show repeat customers only. I know a Pivot table can do the count function but it will also show all customers.

  7. #7
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Formula to show repeat customers

    Using a combination of new columns (Unique, Vlookup, Countif) I was able to add a column that holds the count of previous purchases by that company. Let me know if you have any questions.

    To achieve the objective, I first used UNIQUE to identify the unique companies in the list. I then used the COUNTIF formula to add up all the unique references in the list of companies. I then Used a Vlookup to associate the number of repeat purchases to the parent list. I hope that clears up the process.
    Attached Files Attached Files
    Last edited by maniacb; 06-09-2020 at 07:28 PM.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Formula to show repeat customers

    Andreeas & maniacB

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  9. #9
    Forum Contributor
    Join Date
    07-14-2014
    Location
    New City, NY
    MS-Off Ver
    2016
    Posts
    181

    Re: Formula to show repeat customers

    Thank you Maniacb. This is exactly what I was looking for. Appreciate your help with this.

+ 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. Need Repeat Customers From This data, Considering the date also.
    By Biplab Saha in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-01-2020, 12:24 PM
  2. Create Formula, Repeat Formula, Move to next Worksheet and repeat
    By sparkyster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2018, 03:23 PM
  3. Replies: 1
    Last Post: 10-06-2017, 06:31 AM
  4. Replies: 4
    Last Post: 03-08-2014, 08:01 AM
  5. Merging sheets to find repeat customers
    By cmax979 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-10-2013, 02:09 PM
  6. Determine repeat customers vs. new customers based on purchase date
    By mktgdude in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 04:10 AM
  7. pivot chart to show status of customers with more than one condition
    By applesandpears in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-30-2013, 06:58 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