I have just completed a spreadsheet of orders of publications from my office, with quantity of the publication ordered and the requester of the publication speficied. Often there are multiple orders from the same requester across a period of months, and I would like to create a simple chart showing who orders the most- but when I do this, I do get most of what I want, but multiple instances of the same requester at different dates are not grouped together like I want them to be. In my bar chart I get multiple bars for groups with more than one entry and what I need is for it to be one bar for each group with the total number of publications ordered.
So my question is, instead of 5 seperate entries with the requester as "group A" and different quantities and dates for each entry, how can I get Excel to merge identical requester entries and add up the quantity of publications ordered so I just get one data point out of it?
Thanks much in advance folks!
Bookmarks