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

[meeravijayan2011]

Spoiler

Spoiler

[mbogusz]

Took the join and summarize route (don't try this at home) vs. recordID and multi-row formula route (simply the best).

Spoiler

[arjanloogman]

Quick one... did not use the recordID route, but just another multi-row-formula...

Spoiler

 

Hav a nice day!!

[ddiesel]

My solution:

Spoiler

I got so excited about the Multi-Row formula tool, that I used it instead of Record ID at the start. Had it solved in under two minutes, but then felt a little silly when I saw the "standard answer" starting with RecordID.

[JA]

Spoiler

[T_Willins]

Reposting to add attachment.

Spoiler

[justindavis]

Spoiler

Two minutes... curious what leads to this one being classified as intermediate versus beginner? Is it the tools that are most likely to be used?

[Xlblaze]

Spoiler

My Solution

 Also a little confused as to how this is intermediate rather than beginner.

[ImranA]

Spoiler

First posted completed Challenge, we did a mini grand prix and I did it differently to my colleague/tutor! He was a little quicker though 😞