Hi

I am analysing a large amount of data related to monthly product sales and would like to extract the top selling products within various categories in an automatic manner. I know this can be done manually by using the filter and twisting things around, but I need it to be as automatic as possible - and since this is monthly data the top products might change depending on the period.

I am currently using the conditional sum to get the sums of all the products sold within the various categories, but need to find a formula that at the same time sorts the data so I only get the top products. Any tips?

Would very much appreciate your help!