Please_H
Board Regular
- Joined
- Apr 16, 2017
- Messages
- 181
- Office Version
- 2019
- Platform
- Windows
Dear All,
I am in need of Finding the Ranking of Top 40 Companies among a list of Companies...
I shall explain the example below,
The Data set is almost identical to the above and its a table.
What I need is a Formula to work with, determine the Rank within an year as well as identifying Quarter-wise ( meaning Jan-Mar as Q1, Apr-Jun as Q2 ) like-wise.
Any help would be highly appreciated.
Thank you.
I am in need of Finding the Ranking of Top 40 Companies among a list of Companies...
I shall explain the example below,
Month | Year | Company Name | Revenue | 2020 | Revenue | Rank | ||||||
Jan-20 | 2020 | A | 50.00 | A | 90.00 | D | 370.00 | |||||
Jan-20 | 2020 | B | 100.00 | B | 210.00 | 3 | C | 365.00 | ||||
Jan-20 | 2020 | C | 75.00 | C | 365.00 | 2 | B | 210.00 | ||||
Jan-20 | 2020 | D | 25.00 | D | 370.00 | 1 | ||||||
Jan-20 | 2020 | E | 15.00 | E | 155.00 | |||||||
Jan-20 | 2020 | A | 10.00 | |||||||||
Jan-20 | 2020 | B | 90.00 | 2021 | Rank | |||||||
Feb-20 | 2020 | C | 110.00 | A | 290.00 | B | 1,310.00 | |||||
Feb-20 | 2020 | D | 125.00 | B | 1,310.00 | 1 | D | 470.00 | ||||
Feb-20 | 2020 | E | 25.00 | C | 465.00 | 3 | C | 465.00 | ||||
Feb-20 | 2020 | A | 15.00 | D | 470.00 | 2 | ||||||
Feb-20 | 2020 | B | 10.00 | E | 255.00 | |||||||
Feb-20 | 2020 | C | 90.00 | |||||||||
Feb-20 | 2020 | D | 110.00 | |||||||||
Feb-20 | 2020 | E | 25.00 | |||||||||
Feb-20 | 2020 | A | 15.00 | |||||||||
Aug-20 | 2020 | B | 10.00 | |||||||||
Aug-20 | 2020 | C | 90.00 | |||||||||
Aug-20 | 2020 | D | 110.00 | |||||||||
Aug-20 | 2020 | E | 90.00 | |||||||||
Jan-21 | 2021 | A | 150.00 | |||||||||
Jan-21 | 2021 | B | 1,100.00 | |||||||||
Jan-21 | 2021 | C | 175.00 | |||||||||
Jan-21 | 2021 | D | 125.00 | |||||||||
Jan-21 | 2021 | E | 115.00 | |||||||||
Jan-21 | 2021 | A | 110.00 | |||||||||
Jan-21 | 2021 | B | 190.00 | |||||||||
Feb-21 | 2021 | C | 110.00 | |||||||||
Feb-21 | 2021 | D | 125.00 | |||||||||
Feb-21 | 2021 | E | 25.00 | |||||||||
Feb-21 | 2021 | A | 15.00 | |||||||||
Feb-21 | 2021 | B | 10.00 | |||||||||
Feb-21 | 2021 | C | 90.00 | |||||||||
Feb-21 | 2021 | D | 110.00 | |||||||||
Feb-21 | 2021 | E | 25.00 | |||||||||
Feb-21 | 2021 | A | 15.00 | |||||||||
Aug-21 | 2021 | B | 10.00 | |||||||||
Aug-21 | 2021 | C | 90.00 | |||||||||
Aug-21 | 2021 | D | 110.00 | |||||||||
Aug-21 | 2021 | E | 90.00 | |||||||||
The Data set is almost identical to the above and its a table.
What I need is a Formula to work with, determine the Rank within an year as well as identifying Quarter-wise ( meaning Jan-Mar as Q1, Apr-Jun as Q2 ) like-wise.
Any help would be highly appreciated.
Thank you.