Hi,
I have sample data in A:B and would like in columns D:E to extract from this the top and bottom 5 products by total sales.
The results that I would expect from my sample data are shown in D:E in the screenshot below.
The sales for each product is simply the sum of the Sales in column B.
Getting the top and bottom 5 products by total sales can easily by done with a Pivot Table but a formula solution would be far more helpful for my purposes.
Is there a formula that someone could please suggest?
Thanks!
I have sample data in A:B and would like in columns D:E to extract from this the top and bottom 5 products by total sales.
The results that I would expect from my sample data are shown in D:E in the screenshot below.
The sales for each product is simply the sum of the Sales in column B.
Getting the top and bottom 5 products by total sales can easily by done with a Pivot Table but a formula solution would be far more helpful for my purposes.
Is there a formula that someone could please suggest?
Thanks!