League Table Ranking

[tryingtoexcelatexcel]

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.

[tryingtoexcelatexcel]

I should add that if both markets have a rank of 5 I need to show both as 5 because they will receive those 5 points. So the rankings will become points 1, 2, 3, 4, 5, 5, and then 7. So using rank EQ is fine but index match wont work for it.

[tryingtoexcelatexcel]

Hi All,

Any help would be very much appreciated.

[bebo021999]

Choose which week to be recent week in cell B1
See attachment.

[tryingtoexcelatexcel]

Thank you very much. I've actually found a workaround as well but it requires a few helper cells. Thank you very very much Bebo.