Hi guys, I was hoping you could help.
I'm trying to put together a spreadsheet which, based on individual transaction information, will tell me which items sell most often (how many). I've played around with a Pivot Table and with Filters but haven't been able to crack it. I'm more likely to crack my head on the wall I've been banging it against!
Attached is an example of my worksheet:
It is a list of purchases made on various days over time, by different companies.
What I need the sheet to do is look down the list of Item Codes, and for each item, return the total number sold.
The last two columns were my attempts to do this by creating in the first a list of each individual item code and then using the adjacent cells in to add a formula which will lookup the item code and add together the sum of the relevant quantities. Having failed with that I tried using filters but whilst that seems to be a step in the right direction it still doesn't give me a summary of the total sold for each item. So then I heard of Pivot Tables and tried that but I really don't know enough about Filters or Pivots to pull this off.
Could someone help please?
Thanks.
Bookmarks