Glenn, Thank you for looking at this, i am open to change, after seeing your results and looking at my the information that I posted. it was Clear that I failed to properly communicate that information "AKA" the Scores are greater than 10 weeks, Which is when my issues / frustation started. I am using the moving average array only because the team leads will be enter more scores for the next 16 weeks and as the scores get entered the Average should only be based the newest 7 scores entered excluding the largest " one time" Value.

1. my apologies for not providing a clear message
2. I need the 7 most recent scores while excluding the one off high Score
3. Need to display the number being used to calculate the average "visual validation" for the players
4. this needs to be a rolling 16 or more weeks moving average