Challenge #169: Women's World Cup Wins

[MRNuckles]

solution

[Adrien_Sourdille]

Spoiler

[Wanhope]

Spoiler

 

[Towers]

fun one

[kristiadiuisan]

Spoiler

[syahya]

Spoiler

 

[mertshepard]

Solution attached.

[Antoinette]

[WJDinneen]

I took a little liberty with this one, just to experiment a bit more .. I assigned points (much like they do in the World Cup - 3 pts per victory, 1 pt for a draw, 0 for a loss).  The expected country still winds up on top of the table....

Spoiler

[katestrohm]

1. Input tool: Read it as delimited text file - other - insert \t

2. Formula tool to create a row with the winner in each match

3. Summarize tool: Group by winner and Count Winner