Dynamic Tracking of Players

[devil4mheaven]

I’m making a sheet which can track the daily match stats & amount
earned.
There are in total 7 people who have to be divided into 2 teams. Yes,
1 team will be short of a player.
There are almost 60 matches between
different teams.
Each week the team changes randomly. What I need is how will
I be able to keep a tracking of how much each player has won, as the team
changes per week.
I have maintained a sheet for
1) weekwise matches which
will give me either Team A or Team B as winner
2) Team for a current
week.
So to rephrase the question again, how will I dynamically check
weekwise, whether a player belonged to Team A || Team B & update individual
stats accordingly

 

[Drrellik]

I am sure you have assigned each player a number 1 - 7 for the purpose of scrambling the teams up during the 60 different matches. just use a count if formula to count the number of times 1 - 7 appears on the winning side, depending on how you set up your sheet. I pivot table is a very powerful tool an can do it as well.