Spreadsheet: 830420d1684912185-creating-a-formula-to-return-the-average-of-the-top-5-scores-for-a-certain-player-in-table-season-long-ppr-rankings-session-1-2023
Sheet: ScoreMagic

Player Name | PPR Score | Game Name | Rank | Top 5
[NAME] | 6.68 | A League of Their Own - week 6
[NAME] | 6.15 | A League of Their Own - Week 1
[NAME] D | 5.9 | A League of Their Own - Week 1
[NAME] | 5.77 | A League of Their Own - Week 1
[NAME] | 5.65 | A League of Their Own - Week 1
[NAME] | 5.53 | A League of Their Own - Week 1
[NAME] | 5.27 | A League of Their Own - Week 1
[NAME] | 3.93 | A League of Their Own - Week 1
[NAME] D | 5.6 | A League of Their Own - week 2
[NAME] | 5.58 | A League of Their Own - week 2
[NAME] | 5.54 | A League of Their Own - week 2
[NAME] | 5.52 | A League of Their Own - week 2
[NAME] | 5.48 | A League of Their Own - week 2
[NAME] | 5.47 | A League of Their Own - week 2
[NAME] | 6.2 | A League of Their Own - Week 1
[NAME] | 4.94 | A League of Their Own - week 2
Kyle N | 4.15 | A League of Their Own - week 2
[NAME] | 6.59 | A League of Their Own - week 3
[NAME] D | 6.52 | A League of Their Own - week 3
[NAME] | 6.29 | A League of Their Own - week 3
[NAME] | 6.27 | A League of Their Own - week 3
[NAME] | 6.14 | A League of Their Own - week 3
[NAME] | 6.12 | A League of Their Own - week 3
Wags | 6.12 | A League of Their Own - week 3
Kyle N | 5.92 | A League of Their Own - week 3
[NAME] | 5.65 | A League of Their Own - week 3
[NAME] | 6 | A League of Their Own - week 4
[NAME] | 5.52 | A League of Their Own - week 3
[NAME] | 4.64 | A League of Their Own - week 3
Wags | 6.55 | A League of Their Own - week 4
[NAME] | 5.67 | A League of Their Own - week 9
[NAME] | 5.78 | A League of Their Own - week 4
[NAME] | 5.75 | A League of Their Own - week 4
[NAME] | 5.71 | A League of Their Own - week 4
[NAME] | 5.6 | A League of Their Own - week 4
[NAME] | 4.76 | A League of Their Own - week 4
[NAME] | 4.74 | A League of Their Own - week 4
[NAME] | 4.52 | A League of Their Own - week 4
[NAME] D | 6.82 | A League of Their Own - week 4
[NAME] | 6.65 | A League of Their Own - week 5
[NAME] | 5.89 | A League of Their Own - week 5
[NAME] | 5.56 | A League of Their Own - week 3
[NAME] | 4.95 | A League of Their Own - week 5
[NAME] | 4.82 | A League of Their Own - week 5
Kyle N | 4.62 | A League of Their Own - week 5
[NAME] | 4.32 | A League of Their Own - week 5
[NAME] | 7.35 | A League of Their Own - week 6
[NAME] | 7.22 | A League of Their Own - week 6
[NAME] | 5.45 | A League of Their Own - week 2
[NAME] | 6 | A League of Their Own - week 6
[NAME] | 5.67 | A League of Their Own - week 6
[NAME] D | 5.4 | A League of Their Own - week 6
[NAME] | 5.11 | A League of Their Own - week 6
Kyle N | 3.94 | A League of Their Own - week 6
[NAME] | 7.32 | A League of Their Own - week 7
[NAME] | 6 | A League of Their Own - week 7
Wags | 5.96 | A League of Their Own - week 7
[NAME] | 5.62 | A League of Their Own - week 7
[NAME] | 5.62 | A League of Their Own - week 7
[NAME] | 5.46 | A League of Their Own - week 7
[NAME] | 5.35 | A League of Their Own - week 8
[NAME] | 4.5 | A League of Their Own - week 7
[NAME] D | 7.11 | A League of Their Own - week 8
Wags | 6.73 | A League of Their Own - week 8
[NAME] | 6.7 | A League of Their Own - week 8
[NAME] | 6.6 | A League of Their Own - week 8
[NAME] | 6.35 | A League of Their Own - week 8
[NAME] | 6 | A League of Their Own - week 8
[NAME] | 5.83 | A League of Their Own - week 8
[NAME] | 5.5 | A League of Their Own - week 8
[NAME] | 5.33 | A League of Their Own - week 5
[NAME] | 4.65 | A League of Their Own - week 8
Kyle N | 1.23 | A League of Their Own - week 8
[NAME] D | 6.76 | A League of Their Own - week 9
[NAME] | 6.63 | A League of Their Own - week 9
[NAME] | 6.02 | A League of Their Own - week 9
[NAME] | 5.83 | A League of Their Own - week 9
[NAME] | 5.27 | A League of Their Own - week 7
Wags | 5.61 | A League of Their Own - week 9
[NAME] | 4.09 | A League of Their Own - week 9
Kyle N | 3.26 | A League of Their Own - week 9
 |  |  | [NAME]