aturetsky
asked on
need breakdown by number of games bought
I have a spreadsheet with three columns (see attached sample - note, all names have been changed). I need an excel chart that would show many users bought 1 game, how many users bought 2 games, how many users bought 3 games, and so on.
How would I do that? purchases.xlsx
How would I do that? purchases.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, but how do I get the breakdown I requested, not merely the number of games per user.
ASKER
Excellent, Glenn - thanks so much. I am about to post another, related question. I will post a link to that question here shortly.
Glad I could help...I will keep an eye out for your follow-up question.
ASKER
The related question is here: https://www.experts-exchange.com/questions/27312416/need-a-line-chart-of-weekly-app-sales.html
I would use a pivot table and pivot chart for this. It will count the number of games for you. I've attached an example.
Pivot-Example.xls