League Table Ranking

Hi All,

I am trying to create a ranking table but am running into several problems. Please see attached file.

I'm trying to get a ranking to show the latest week (W3) but also to show weeks 1 and 2 for that office.

So for example if Shanghai is ranked number 1 in W3 I'm trying to show it appear in the first place and also show the points it had for W1,2,3.

I thought I could use an Index Match but so far it is a very manual process because I would have to move each week to "match" the latest week.

Also when a ranking is the same between markets for example America and Europe both have 5 then the index match goes into some trouble.

I am using Rank EQ and it will give me for example 2 rank 11's and then jump to rank 13.

Thank you very very very very very very much for your help.