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!
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!
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!!!!
See attached....
Is this what you are looking for?
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.
Here is another view, but ANDREAAS option is pretty close.
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.
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.
Last edited by maniacb; 06-09-2020 at 07:28 PM.
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.
Thank you Maniacb. This is exactly what I was looking for. Appreciate your help with this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks