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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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
296
RoryA
RoryA
S
  • Question Question
analyze and export based on multiple criteria
Replies
0
Views
537
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,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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