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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Drrellik

Well-known Member
Joined
Apr 29, 2013
Messages
773
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,030
Messages
5,835,038
Members
430,333
Latest member
jaypatel1298

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