Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
This was a brainteaser!
and a Headscratcher!
Spoiler
Step 2: build a list of "rank" starting at 1 ... but if this row's Rating = last row's rating, then fill this row with last row's ranking.
If it's the first time we've got the rank in the list, then we can accumulate this rank with last row's ranking PLUS the previous row's cumulative count.
Bleurgh! The trick here is to use the balance b/f!
I've also been developing this habit of "seeding" my lists created in the multi-row formula with a 1 (i.e. if [Row-1:something] = 0 then 1) haven't figured out if I like this or not yet!
Step 1: create a column that is the cumulative count of the number of unique appearances that a Rank appears in the list
so if 7 appears twice ... the "count" should go 1 and then 2
Step 2: build a list of "rank" starting at 1 ... but if this row's Rating = last row's rating, then fill this row with last row's ranking.
If it's the first time we've got the rank in the list, then we can accumulate this rank with last row's ranking PLUS the previous row's cumulative count.
Bleurgh! The trick here is to use the balance b/f!
I've also been developing this habit of "seeding" my lists created in the multi-row formula with a 1 (i.e. if [Row-1:something] = 0 then 1) haven't figured out if I like this or not yet!
