Dynamic Tracking of Players

devil4mheaven

New Member
Joined
Apr 3, 2013
Messages
1
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Drrellik

Well-known Member
Joined
Apr 29, 2013
Messages
770
Office Version
  1. 365
  2. 2016
  3. 2013
  4. 2011
  5. 2010
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,842
Messages
5,598,396
Members
414,235
Latest member
sucosama

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top