Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Challenge #122: Think Like a CSE...Ranking Data

LHolmes
9 - Comet

Two solutions attached.

 

Spoiler
122 - Solution.PNG
MichaD
8 - Asteroid

My solution:

shadakht
6 - Meteoroid

Here is my approach!!

izamryan
8 - Asteroid

This was a brainteaser!

and a Headscratcher!

 

Spoiler
izamryan_0-1590709559594.png


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!
johnemery
11 - Bolide

Simple, yet clever solution (that many others have already posted).

 

Spoiler
Capture.PNG
balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590972810748.png

 

EW
11 - Bolide

Three tools...  And I realize now seeing other solutions it could have been two!

 

Spoiler
122 EW.PNG
Jur
7 - Meteor

My solution:

Spoiler
Challenge_122_JP.PNG
Aaron12
5 - Atom

Great challenge!

subhajits11
8 - Asteroid

I have some fun with "Review Rank 2" 

 

Spoiler
SpoilerIndexingIndexing