Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThe 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.
@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).
A little bit of a tricky one, but here's my solution for challenge #9!