Forum Discussion

Andy_MR's avatar
Andy_MR
Copper Contributor
Jul 28, 2023

Skittles Averages

Hi 

I am hoping someone can help me. I have taken over the Skittles Club Averages/ M,F/scores/tables.

I would like to set up a weekly individual Averages for Male and Female, there is 10 teams in 2 divisions with up to 16 players in each team. on several tabs 

 

Is there a way I could set this up in a separate table which is updated every time I enter the weekly scores 

If this is possible please break this down to a simple guide on how to do it. It's been a long time since using Excel and the first time using this forum.

(This is being done on a Mac Book Pro) 

 

Your help is appreciated. 

Andy

2 Replies

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    You have 46 views and no replies so far. The requests here that get the most attention usually include a sample workbook (Attached or hosted on OneDrive) so there's something to go off. It's difficult to make any recommendations or create formulas without seeing something.
  • Andy_MR's avatar
    Andy_MR
    Copper Contributor
    I forgot to say this would change each week as you can only be included in the averages when you play so many games ( if you understand where I am coming from) in a nut shell you have to play 66% of games to be included.

Resources