I've recently started sports blogging and I'm looking to do some statistical analysis. I've used a web scraper to record various statistics (Shots, passes, possession etc.) in all major league soccer games for the last 5 years. It looks something like this:
<tbody>
</tbody>
There's roughly 500 teams in questions and I'd like to build a data base for each team. However I can't use to filter by home team because then I miss that teams away matches. I could filter by home matches and away and copy and paste but that would take a lot of maintenance since there are hundreds of matches every week. As a relatively inexperienced excel user, I am wondering if there is some macro that can read the one large spreadsheet of all matches (Like the one above but way bigger) and deliver just the matches of a certain team on a different sheet like this:
<tbody>
</tbody>
Its quite an unusual situation so I haven't been able to find much related material through searches. Any idea what topics I should be looking into to build something like this? Also for anyone with SQL experience, I've been told that the kind of data I have is very suited to SQL instead of having 500 sheets floating around, would you agree?
Home Team | Away Team | Home Possession | Away Possession |
Liverpool | Barcelona | 55% | 45% |
Arsenal | Chelsea | 50% | 50% |
Chelsea | Liverpool | 45% | 55% |
Barcelona | Liverpool | 60% | 40% |
<tbody>
</tbody>
There's roughly 500 teams in questions and I'd like to build a data base for each team. However I can't use to filter by home team because then I miss that teams away matches. I could filter by home matches and away and copy and paste but that would take a lot of maintenance since there are hundreds of matches every week. As a relatively inexperienced excel user, I am wondering if there is some macro that can read the one large spreadsheet of all matches (Like the one above but way bigger) and deliver just the matches of a certain team on a different sheet like this:
Liverpool | |||
Liverpool | Barcelona | 55% | 45% |
Chelsea | Liverpool | 45% | 55% |
Barcelona | Liverpool | 60% | 40% |
<tbody>
</tbody>
Its quite an unusual situation so I haven't been able to find much related material through searches. Any idea what topics I should be looking into to build something like this? Also for anyone with SQL experience, I've been told that the kind of data I have is very suited to SQL instead of having 500 sheets floating around, would you agree?