Hi Guys,
I would really appreciate any help with this.
Basically, I run a sales report that comes off in a format like the example attached.
It shows every order that a customer has placed over a period of time. I am trying to build a spreadsheet that will add all the same customers names & show me how much $ they have spent collectively.
I am trying to find out who our biggest accounts are. I would like to bar graph it too if possible.
So basically- right now its like this:
Customer ----------- Order $
A ------------- $5
A ------------- $5
A ------------- $5
and I want to make a spreadsheet that automatically makes it like this:
Customer --------- Order $
A ----------- $15
Bookmarks