Conditional Weighted Averages of Athlete Performances

yonderkens

New Member
Joined
Mar 9, 2018
Messages
1
Hello everyone,

I need to report weighted averages of athletes' performances based on when they played, who they played against, and their positions.

Here is an example to clarify:

Let's say I'm looking at Team A. I want to know how all of the players in Position X who have played against Team A since Round n have performed on average against all teams since Round n.

The logical steps should look like this:

1. Find all of the players in Position X who played against Team A since round n by name, removing any duplicates.
2. Use those names to find the data of each game of each of those players since round n ( against Team A, Team B, Team C, and so on for however many teams they played against since Round n).
3. Calculate the weighted average

I've tried writing several codes to handle this, but I always get lost in complicated nested for loops and dynamic arrays.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Hi yonderkens.

You will need to post some sample data for us to be able to help.

If you post both data and your current code then we will be able to help even more.

We might know excel well, but unfortunately we're not psychic ! :)

Cheers,

Warren.
 
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,718
Members
448,294
Latest member
jmjmjmjmjmjm

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
Back
Top