Sum of Sales for top 4 firms per year per industry

[Cunner]

Hi everyone,

I have a table with firms, their industry and their sales data for a couple of years each.
I want to get the sum from the four firms per year per industry with the highest sales.

Does anyone know how to do this (easily)?

I tried a formula in Cell G2, but this doesn't work...

Any help is appreciated.

[ARGK]

Hi
Which Column defines your industry?
Tony

[Cunner]

Column E, "2-digit SIC"

[Cunner]

Hi everyone, anyone has some advice?

[jaslake]

Hi Cunner
Here's one way with Code

Please Login or Register  to view this content.

[jaslake]

Hi Cunner

You're welcome...glad I could help.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save