Hi all,
I have a large set of data that looks very roughly like this with many different values in each column.
Type Category Item Sales Quarter Year
Book Adventure 123 100 2 2010
Book Adventure 123 100 1 2011
Book Adventure 123 200 2 2010
Book Adventure 321 200 2 2010
Book Adventure 321 300 2 2010
Book Adventure 444 100 2 2010
Book Adventure 444 100 2 2010
What I would like to do is find the top 10 items in order of sales for a specified type/category/quarter/year combination. So for Adventure Books for Q2 2010, which items had the most sales; subtotal those sales and present the top 10 items with sales on a separate worksheet, ala
Item Sales
321 500
123 300
444 200
Can somebody point me in the proper direction by mentioning some formulas, VBA, logic that you would start with? Let's say no PivotTable suggestions please and I'd prefer if you just didn't post what you thought was the right formula/VBA - I'd like to learn with a little push from you.
Bookmarks