We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #9: Analytics Ranking

LindaLo
8 - Asteroid

I used multi row formula 

and its also interesting to see another solution from you

 

aanandkumar
8 - Asteroid
 
JonKennah
6 - Meteoroid
Spoiler
Spolier 9.PNG
Desmond
8 - Asteroid

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
5 - Atom

@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
7 - Meteor
Spoiler
Solution
Siobhan_Purcell
8 - Asteroid
Spoiler
Siobhan_Purcell_0-1581246883423.png

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

garymitter
5 - Atom

Have solved, my first weekly challenge solution.

smitapote
6 - Meteoroid

Challenge 9 Solution attached

Igor_Garlowski
7 - Meteor