Challenge #9: Analytics Ranking

[LindaLo]

I used multi row formula 

and its also interesting to see another solution from you

[JonKennah]

Spoiler

[Desmond]

The challenge asks that you rank similar to golf rankings.  If this were the case then if two people were tied for 1st then there would be no ranking of 2nd, it would then go to 3rd and so on.  I was able to get to the answer but the workflow would need to be adjusted slightly to get to an answer that is truly like a golf rank.  Still a fun and quick challenge.

[Bhavna]

@BenMoss Defo prefer your solution!

But if you only wanted to keep the top 5 people, how would you do it?

The Sample tool wouldn't work as it would only allow you to keep the first 5 rows (and therefore, only keep those ranked 1-3).

[black28]

Spoiler

Solution

[Siobhan_Purcell]

Spoiler

A little bit of a tricky one, but here's my solution for challenge #9!

[garymitter]

Have solved, my first weekly challenge solution.

[smitapote]

Challenge 9 Solution attached