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

ldean
8 - Asteroid

My solution.

Vanzeup7
7 - Meteor

Here's my solution. Thanks.

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1613813953333.png

 

Nice quick one. I've attached two solutions - one to mirror the "rank" provided, the other to derive a true rank.  eg Sharon is in a tie for 10th place, not 5th.  Likewise Paul would be ranked 3rd so he would win a bronze, not silver - there would be no silver medal.

mdsalmankhan89
8 - Asteroid

Nice to implement ranking using mutlirow formula. 

Here is my solution.

lkclooney
7 - Meteor

Solution attached. Highlight below.

 

lkclooney_0-1614224318519.png

 

mot
11 - Bolide

Solution attached.

LynCorcoran
5 - Atom

Solution uploaded

🙂

Luke_C
12 - Quasar
Spoiler
Challenge009.PNG

vPir
7 - Meteor

Hi, this is my solution

Vagner

abanana
6 - Meteoroid
Spoiler
abanana_0-1614879376645.png

 

Multiple good ways to approach this. Here's what I went with!