Sorting summary data on one sheet to another sheet by rank

[thaithco]

I have created a Workbook that has a worksheet for each day of the month. Then each day there is a log of events setup with Providers listed down col A and possible events listed in the top Row. On the last worksheet I have the monthly totals which I have formulas showing the monthly total events by category. I would like to take the Total monthly events tab and have another sheet that is constantly looking at the Total events and sorting them by highest to lowest rank by events. But can't figure out a formula to use that will constantly have data sorted from one sheet on to another everytime the workbook is opened. This will allow at a glance to gauge productivity of the people listed in Col A.

Any help would be greatly appreciated!

Tom

 

[jimrward]

firstly you need to make sure that the RANKing is unique so you have to use one of the many formulae from a google search not the excel RANK function

you can then use a combination of INDEX and MATCH to look for rank=1, rank=2 etc to form your league table, I have some examples but not at work