Best way to analyse sports data

T

t19tom

New Member
Joined
Aug 2, 2017
Messages
2
I'm interested in analysing some fantasy football data to see the consistent high points scorers each season. I want to be able to easily view points totals per year per player from multiple tables, one for each year.

I can't seem to work out the best way to merge the data so i can see player names per row and each years total points as columns. It sounds like it should be easy but I'm stuck! What is the best way in Excel to do this?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
Can anyone point me to any features or functions in Excel that I can look at to get what I need?

Below is some sample data - I want to end up with one table or view where I can see total points per player per year.

[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 54, bgcolor: transparent"]Year
[/TD]
[TD="width: 89, bgcolor: transparent"]Name
[/TD]
[TD="width: 35, bgcolor: transparent"]Club
[/TD]
[TD="width: 28, bgcolor: transparent"]Val
[/TD]
[TD="width: 28, bgcolor: transparent"]Tot
[/TD]
[TD="width: 21, bgcolor: transparent"]G
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-17
[/TD]
[TD="bgcolor: transparent"]D de Gea
[/TD]
[TD="bgcolor: transparent"]MU
[/TD]
[TD="bgcolor: transparent, align: right"]4
[/TD]
[TD="bgcolor: transparent, align: right"]132
[/TD]
[TD="bgcolor: transparent, align: right"]36
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-17
[/TD]
[TD="bgcolor: transparent"]J Hart
[/TD]
[TD="bgcolor: transparent"]Out
[/TD]
[TD="bgcolor: transparent, align: right"]3.8
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-17
[/TD]
[TD="bgcolor: transparent"]P Cech
[/TD]
[TD="bgcolor: transparent"]Ars
[/TD]
[TD="bgcolor: transparent, align: right"]3.8
[/TD]
[TD="bgcolor: transparent, align: right"]120
[/TD]
[TD="bgcolor: transparent, align: right"]37
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-17
[/TD]
[TD="bgcolor: transparent"]H Lloris
[/TD]
[TD="bgcolor: transparent"]Tot
[/TD]
[TD="bgcolor: transparent, align: right"]3.7
[/TD]
[TD="bgcolor: transparent, align: right"]137
[/TD]
[TD="bgcolor: transparent, align: right"]35
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-17
[/TD]
[TD="bgcolor: transparent"]T Courtois
[/TD]
[TD="bgcolor: transparent"]Che
[/TD]
[TD="bgcolor: transparent, align: right"]3.8
[/TD]
[TD="bgcolor: transparent, align: right"]152
[/TD]
[TD="bgcolor: transparent, align: right"]39
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-17
[/TD]
[TD="bgcolor: transparent"]S Mignolet
[/TD]
[TD="bgcolor: transparent"]Liv
[/TD]
[TD="bgcolor: transparent, align: right"]3.5
[/TD]
[TD="bgcolor: transparent, align: right"]100
[/TD]
[TD="bgcolor: transparent, align: right"]28
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-17
[/TD]
[TD="bgcolor: transparent"]K Schmeichel
[/TD]
[TD="bgcolor: transparent"]Lei
[/TD]
[TD="bgcolor: transparent, align: right"]3.6
[/TD]
[TD="bgcolor: transparent, align: right"]76
[/TD]
[TD="bgcolor: transparent, align: right"]32
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Year
[/TD]
[TD="bgcolor: transparent"]Name
[/TD]
[TD="bgcolor: transparent"]Club
[/TD]
[TD="bgcolor: transparent"]Val
[/TD]
[TD="bgcolor: transparent"]Tot
[/TD]
[TD="bgcolor: transparent"]G
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2015-16
[/TD]
[TD="bgcolor: transparent"]J Hart
[/TD]
[TD="bgcolor: transparent"]MC
[/TD]
[TD="bgcolor: transparent, align: right"]3.8
[/TD]
[TD="bgcolor: transparent, align: right"]129
[/TD]
[TD="bgcolor: transparent, align: right"]35
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2015-16
[/TD]
[TD="bgcolor: transparent"]D de Gea
[/TD]
[TD="bgcolor: transparent"]MU
[/TD]
[TD="bgcolor: transparent, align: right"]3.8
[/TD]
[TD="bgcolor: transparent, align: right"]148
[/TD]
[TD="bgcolor: transparent, align: right"]40
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2015-16
[/TD]
[TD="bgcolor: transparent"]P Cech
[/TD]
[TD="bgcolor: transparent"]Ars
[/TD]
[TD="bgcolor: transparent, align: right"]3.7
[/TD]
[TD="bgcolor: transparent, align: right"]137
[/TD]
[TD="bgcolor: transparent, align: right"]35
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2015-16
[/TD]
[TD="bgcolor: transparent"]H Lloris
[/TD]
[TD="bgcolor: transparent"]Tot
[/TD]
[TD="bgcolor: transparent, align: right"]3.6
[/TD]
[TD="bgcolor: transparent, align: right"]129
[/TD]
[TD="bgcolor: transparent, align: right"]37
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2015-16
[/TD]
[TD="bgcolor: transparent"]J Ruddy
[/TD]
[TD="bgcolor: transparent"]Nor
[/TD]
[TD="bgcolor: transparent, align: right"]2.7
[/TD]
[TD="bgcolor: transparent, align: right"]49
[/TD]
[TD="bgcolor: transparent, align: right"]28
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2015-16
[/TD]
[TD="bgcolor: transparent"]W Szczesny
[/TD]
[TD="bgcolor: transparent"]Out
[/TD]
[TD="bgcolor: transparent, align: right"]3.4
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2015-16
[/TD]
[TD="bgcolor: transparent"]T Howard
[/TD]
[TD="bgcolor: transparent"]Eve
[/TD]
[TD="bgcolor: transparent, align: right"]3.3
[/TD]
[TD="bgcolor: transparent, align: right"]67
[/TD]
[TD="bgcolor: transparent, align: right"]25
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2015-16
[/TD]
[TD="bgcolor: transparent"]A Begovic
[/TD]
[TD="bgcolor: transparent"]Che
[/TD]
[TD="bgcolor: transparent, align: right"]3.2
[/TD]
[TD="bgcolor: transparent, align: right"]48
[/TD]
[TD="bgcolor: transparent, align: right"]18
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Year
[/TD]
[TD="bgcolor: transparent"]Name
[/TD]
[TD="bgcolor: transparent"]Club
[/TD]
[TD="bgcolor: transparent"]Val
[/TD]
[TD="bgcolor: transparent"]Tot
[/TD]
[TD="bgcolor: transparent"]G
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2014-15
[/TD]
[TD="bgcolor: transparent"]J Hart
[/TD]
[TD="bgcolor: transparent"]MC
[/TD]
[TD="bgcolor: transparent, align: right"]4
[/TD]
[TD="bgcolor: transparent, align: right"]120
[/TD]
[TD="bgcolor: transparent, align: right"]36
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2014-15
[/TD]
[TD="bgcolor: transparent"]D de Gea
[/TD]
[TD="bgcolor: transparent"]MU
[/TD]
[TD="bgcolor: transparent, align: right"]3.7
[/TD]
[TD="bgcolor: transparent, align: right"]132
[/TD]
[TD="bgcolor: transparent, align: right"]42
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2014-15
[/TD]
[TD="bgcolor: transparent"]P Cech
[/TD]
[TD="bgcolor: transparent"]Che
[/TD]
[TD="bgcolor: transparent, align: right"]3.8
[/TD]
[TD="bgcolor: transparent, align: right"]36
[/TD]
[TD="bgcolor: transparent, align: right"]9
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2014-15
[/TD]
[TD="bgcolor: transparent"]H Lloris
[/TD]
[TD="bgcolor: transparent"]Tot
[/TD]
[TD="bgcolor: transparent, align: right"]3.4
[/TD]
[TD="bgcolor: transparent, align: right"]87
[/TD]
[TD="bgcolor: transparent, align: right"]35
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2014-15
[/TD]
[TD="bgcolor: transparent"]P Reina
[/TD]
[TD="bgcolor: transparent"]Out
[/TD]
[TD="bgcolor: transparent, align: right"]2.9
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2014-15
[/TD]
[TD="bgcolor: transparent"]W Szczesny
[/TD]
[TD="bgcolor: transparent"]Ars
[/TD]
[TD="bgcolor: transparent, align: right"]3.6
[/TD]
[TD="bgcolor: transparent, align: right"]55
[/TD]
[TD="bgcolor: transparent, align: right"]22
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2014-15
[/TD]
[TD="bgcolor: transparent"]T Howard
[/TD]
[TD="bgcolor: transparent"]Eve
[/TD]
[TD="bgcolor: transparent, align: right"]3.4
[/TD]
[TD="bgcolor: transparent, align: right"]70
[/TD]
[TD="bgcolor: transparent, align: right"]32
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2014-15
[/TD]
[TD="bgcolor: transparent"]A Begovic
[/TD]
[TD="bgcolor: transparent"]Sto
[/TD]
[TD="bgcolor: transparent, align: right"]3.1
[/TD]
[TD="bgcolor: transparent, align: right"]80
[/TD]
[TD="bgcolor: transparent, align: right"]35
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

confuxion
  • Question Question
Best way to make all-time leading scorers sheet from multiple sheets
2 3 4
Replies
33
Views
1K
felixstraube
F
M
  • Question Question
Best way to guarantee data consistency
Replies
2
Views
291
RoryA
RoryA
S
  • Question Question
analyze and export based on multiple criteria
Replies
0
Views
526
slash32487
S
N
  • Question Question
2-step Dynamic Ranges and Charts
Replies
0
Views
1K
Nick Loughton
N
S
  • Question Question
Ranking Data Based on Multiple Criteria
Replies
4
Views
3K
bebo021999
B

Forum statistics

Threads
1,223,910
Messages
6,175,320
Members
452,635
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top