What's the best way to find unique customer in a column for a pivottable? I have a column of customer and then a column of purchases and I want to segment customers into categories (eg. purchased 1, purchased 3, 5, etc). Gracias.
What's the best way to find unique customer in a column for a pivottable? I have a column of customer and then a column of purchases and I want to segment customers into categories (eg. purchased 1, purchased 3, 5, etc). Gracias.
Here is a spreadsheet of a dummy example. Real spreadsheet has many more instances.
maybe like this.
if not add the expected result manualy in the file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks