Pricing problem in Excel

[AndersNOR9]

Hi

I have a large Excel file with price and revenue data for different products for different customers.

Customer ID Product Revenue Jan Revenue Feb . ... .....
Joe´s pizza dough 10000
Joe´s pizza tomatos 42525
Joe´s pizza cheese 52525
.
.
.
Sushi place Samon 5525
Sushi place Wasabi 52525
.
.

There are about 200 customers and 5000 products, what I need is to find the products that are not a top five product (in terms of revenue) for each firm, and for all of those products that most of the firms have in common put on an x% price increase. The revenues in Jan, Feb etc are calculated by volume (in another sheet) times price for the product (in a sheet with prices).

Any ideas, I am kinda clueless.

 

[C Moore]

You would need a sheet that summarizes all products with a revenue sum. You could use large function to find the 6th highest revenue so that everything equal or below could be marked. Countifs to find products with lots of firms.