Challenge #319: Sports Spots

[Kenda]

Saqueador

[FloraF]

Solved!

[TonyAndriani]

Several problems with the provided solution. As @Reesetrain2 noted, Bronx is a borough of New York City. Also, the solution doesn't account for cities that have more than one team in the same league. So New York should be in the list. Excluding the Bronx, it has no NFL or MLS teams but does have two NHL and NBA teams. The question asks how many leagues are represented. The solutions shows a count of 5, should be 3.

Saqueador

[dbrownsc]

Saqueador

Spoiler

[patrick_digan]

Saqueador

I ended up with 48 due to NY Ctiy

[Powerhouse_21]

I created 2 outputs. One has the 48 cities, but outlines each of the Team types and names them. the other has 101 records but that's due to each of the cities having multiple teams. I also kept the Burroughs of NYC separated. 

Saqueador

[phottovy]

My solution:

Saqueador

[JereJussila]

Saqueador

New York City should be included in the solution output

[ejjacobs4]

I used my first macro, that was fun, Also noticed solution was wrong, because New York City has 5 teams but only 3 leagues. I made sure to include the extra teams in the final data, but only count them as 3 unique leagues

Saqueador

[Jeremy]

Attached.  Interesting challenge.  I had some issues with punctuation with the way I implemented this, so I have some replace tools that shouldn't have been necessary.