# Dynamic Tracking of Players

#### devil4mheaven

##### New Member
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

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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.

Replies
0
Views
456
Replies
0
Views
345
Replies
3
Views
325
Replies
3
Views
517
Replies
2
Views
802

1,219,941
Messages
6,151,086
Members
451,007
Latest member
gianmatt

### 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.

### Which adblocker are you using?

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

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