Index with sum Formula
Posted on 2013-06-18
I need to identify the top 10 customers for a selected item. My spreadsheet where I store all the data has individual rows for each sale of my items. There are multiple customers throughout the data. I need to be able to select an item and then have it list the top 10 customers based on sales $$$ for that item. Then I need to also sum up the total quantity sold for those customers for the item selected as well. There can be multiple lines for a customer so I need to sum up all the sales and then show the top 10 customers.
Customer Name = D
Sales $$$ = V
Item # = I
Quantity = AZ
On a separate worksheet I will enter the item # in cell W3 and then I want the top 10 customers to be listed in row 7 thru 16 starting in column W. The sales $$$ in column X, and the quantity in column Y.
Any ideas? I know a pivot table would work best but I don't want to use those in this file.