Hey guys,
First post in the forum and a relative newbie to MS excel (so go easy please! ) and this is way above my station!
I have created a spreadsheet for my sons football team, recording all results etc but need help recording the goal scorers information.
Below is the goal scorers from each game (the list will get bigger as games are played). The format of this I would prefer to keep the same, as it ties in with work that someone else has done.
What I want to do is...
1. Extract each players name from a sheet called Results, to form a list in another sheet called Goalscorers.
2. Calculate the total the number of goals scored for each player and add that to a column in the Goalscorers spreadsheet with the player with the most at the top of the list.
3. Calculate a current scoring streak for each player and add that to a column in the Goalscorers spreadsheet.
4, Calculate a highest scoring streak for each player and add that to a column in the Goalscorers spreadsheet.
5. Be able to add scorers as the games are played into the results spreadsheet and they automatically add the goals and calculate streaks on the goalscorers spreadsheet.
Many thanks in advance for any help. It will be very much appreciated if anyone can help!
First post in the forum and a relative newbie to MS excel (so go easy please! ) and this is way above my station!
I have created a spreadsheet for my sons football team, recording all results etc but need help recording the goal scorers information.
Below is the goal scorers from each game (the list will get bigger as games are played). The format of this I would prefer to keep the same, as it ties in with work that someone else has done.
What I want to do is...
1. Extract each players name from a sheet called Results, to form a list in another sheet called Goalscorers.
2. Calculate the total the number of goals scored for each player and add that to a column in the Goalscorers spreadsheet with the player with the most at the top of the list.
3. Calculate a current scoring streak for each player and add that to a column in the Goalscorers spreadsheet.
4, Calculate a highest scoring streak for each player and add that to a column in the Goalscorers spreadsheet.
5. Be able to add scorers as the games are played into the results spreadsheet and they automatically add the goals and calculate streaks on the goalscorers spreadsheet.
Many thanks in advance for any help. It will be very much appreciated if anyone can help!
Kayne Tosh(3), Tyler Smith(1), Charlie Bonella(1), Josh Myszor(1) |
Kyle Joiner(6), James Breen(2), Kayne Tosh(1), Harley Drinnan(1), Brayden Cumming(1), Josh Myszor(1) |
Kyle Joiner(6), Kayne Tosh(1), James Breen(1), Tyler Smith(1), Chris Laing(1) |
Kyle Joiner(2), Tyler Smith(1) |
Kyle Joiner(2), James Breen(2), Tyler Smith(1), Kayne Tosh(1), Josh Myszor(1) |
Kyle Joiner(1), Josh Myszor(2) |
Kyle Joiner(1), Kayne Tosh(1), Josh Myszor(1), Findlay Christie(1) |
Kyle Joiner(2), Tyler Smith(1), Kyle McNamee(1), James Breen(1), Brayden Cumming(1) |
Kyle Joiner(3), Kayne Tosh(1), Brayden Cumming(1) |
Kyle Joiner(1), Kayne Tosh(2), Josh Myszor(3), Brayden Cumming(1), James Breen(2), Dylan Cartlidge(1) |
Kyle Joiner(1), Josh Myszor(2), Theo Brown(1) |
Kyle Joiner(3), Dylan Kane(1), Brayden Cumming(1), Josh Myszor(1) |