I have a workbook relating to scores in a sporting event. Players are listed under their team name e.g. team name 1 in A1 with players listed in A1:A12, team name 2 in A13 with players listed in A14:A24. I have 5 sheets in the workbook recording the results for separate matches between the (same) teams.
Sheets 6 and 7 are summaries of the results for each team (sheet 6 for team 1, sheet 7 for team 2). Amongst other things I want to list the players who played in the series and how many times they played (the same players won’t necessarily appear in all matches).
Does anyone have any ideas how best to go about this?
Thanks in advance…
Sheets 6 and 7 are summaries of the results for each team (sheet 6 for team 1, sheet 7 for team 2). Amongst other things I want to list the players who played in the series and how many times they played (the same players won’t necessarily appear in all matches).
Does anyone have any ideas how best to go about this?
Thanks in advance…