Hi Experts
As a coach of a junior basketball team, I download the stats of games and put into a table show below. This helps me undertand the oppostition a little better, I have a pivot tabel whih shows each teams wins/losses however due tht format of my table, I can only show the Teams points and not what the opposition scored in the same game. I identify the the two teams that played by field Match# in the table. What I need is a antoher field in the table (i think) that uses the Match# to find the Opponentand then look up the Opponent in the Team field to provide the answer. Maybe it is just the structure of the table I am using? Any help to provide this information would be greatly appreciated.
As a coach of a junior basketball team, I download the stats of games and put into a table show below. This helps me undertand the oppostition a little better, I have a pivot tabel whih shows each teams wins/losses however due tht format of my table, I can only show the Teams points and not what the opposition scored in the same game. I identify the the two teams that played by field Match# in the table. What I need is a antoher field in the table (i think) that uses the Match# to find the Opponentand then look up the Opponent in the Team field to provide the answer. Maybe it is just the structure of the table I am using? Any help to provide this information would be greatly appreciated.