Challenge #9: Analytics Ranking

[Sudhakargoli]

Here is my take on the Challenge#9.

[Dazzerman]

I couldn't resist building two methods for solving this problem.  One much shorter than the other.

Here is my solution :

Spoiler

The first solution required multiple Sort tools, but provides the correct answer.

The second solution is much more elegant and makes use of the Multi-Row tool.

[jridleh]

Spoiler

SPOILER

Fun beginner one!

[mat_budden]

Hi All,

Please find my Result below.

Spoiler

I Sorted based on count, Added a Column with a Formula then used a Multi Row Formula to do the Ranks then Filtered.

Thanks

Mat

[AnnaG]

Solution attached

Thanks

Anna

[KT2]

Spoiler

So a little confused by the "round of golf" statement. By that logic the last individual to be in the top 5 based on count would be Linda. I've included a snippet of my workflow and results as well as today's PGA tournament from Google reference. Let me know if I am thinking about this all wrong. 

for 

[DGL]

1. My workflow:
2. sort tool: by count descending
3. formula tool: rank = 1
4. multi-row formula tool: IF [Row-1:count]>[count] THEN [Row-1:rank]+1 ELSE [Row-1:rank] ENDIF
5. formula tool:[rank] + 1
6. filter tool: [rank] <= 5
7. browse tool
8. Crack open a Coors Original, the champagne of beers.

[jlangl11]

Spoiler

[RoDO]

My solution

Spoiler