Link to home
Start Free TrialLog in
Avatar of aturetsky
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
Avatar of BusyMama
BusyMama
Flag of United States of America image

Hi!

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
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of aturetsky
aturetsky

ASKER

Yes, but how do I get the breakdown I requested, not merely the number of games per user.
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.