Challenge #9: Analytics Ranking

[Marleen23]

Thank you for your helpful suggestion!

Actually, I didn't think of the Summarize tool in this context at all, but I agree that I could use it to replace the "Unique" tool making my first solution less confusing. Or did you refer to something else?

[PeterH23]

Attempt at challenge#9. 

Spoiler

I used the tile tool, as a number of others have previously by the look of it.

[alexandramannerings]

Oh sorry, I meant it in reference to your comment that you wished there was a min/max tool. Summarize with the Min/Max calculations basically is a min/max tool. 

[rwfoxjr]

I started to use the Summary tool, as it turns out many folks did, but then thought that the Unique tool was specifically made for this purpose.

[dshakir]

Thanks GeneR.

[ctmckay18]

Attached is solution to Challenge #9.  Utilized Multi-Row Formula Tool.

[justinjohnson02]

Spoiler

[DanielDharam]

Hey beautiful people. Here is a SUPER convoluted way to solve this. I'm posting my first draft of it so I'm sure by the time you read this, I will have devoured the solution and have committed to memory a method to tackle this type of problem more efficiently. In any case...enjoy this crazy version. 

Spoiler

[MikeLR]

Completed without the aid of a safety net 🙂

Spoiler

Multi-row tool worked for me