Spreadsheet: 738604d1625147805-need-formula-to-show-most-recent-data-calculation-summer-scores
Sheet: 2021 SUMMER LEAGUE SCORES

 | Cells with Yellow background display manually entered data.  Cells in darker Gray display calculated data.. Cells in lighter Gray are labels. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C:\Users\GRANDPA\Desktop\[Summer Scores.xls]2021 SUMMER LEAGUE SCORES | SUM of Y: | 23 | Sum of Z: | 21
457 | League Name: |  |  | BABYLON FRIDAY SENIOR LEAGUE |  |  |  |  |  |  |  |  |  | League Name: |  |  | BABYLON FRIDAY SENIOR LEAGUE
 | Start Date: |  |  | 2021-06-04 00:00:00 |  |  |  |  |  |  |  |  |  | Start Date: Friday, June 4, 2021
 | Vince's INDIVIDUAL RECORD |  |  |  |  |  |  |  |  |  |  |  |  | Team Name: ACHES & PAINS version 2.0
 | Today is Week # | Today's Date Is | Game #1 | Game #2 | Game #3 | Match Series | Match Average | League Average | Total  Pins | High Game Score- Over/Under Average | Match Average Over/Under League Average |  |  | Today is Week # | # [NAME]Date | Opposing Team # or Name | Pre-match-TEAM #2 Statistical Average | Pre-match-   Opposing Statistical Average | Notes | Post-Match-Team's Scratch Pins | Team's Scratch Pins-to-Date | Post-Match-Team's True Sum of Scored Averages | Post Match-Team's True Scratch Average Score | Points Earned Today | Points Lost Today | Team #2's Position - Prior Week's Result | Points Won-to-Date | Points Lost-to-Date | CHECK | CHECK | Today's Date Is |  | TEAM#2: ACHES & PAINS Version 2.0
3 | 1 | 2021-06-04 00:00:00 | 119 | 158 | 106 | 383 | 127.6666666666667 | 127.6666666666667 | 383 | 30.33333333333333 | 0 |  |  | 1 | 12 | Mean Girls | 610 | 514 |  | 1831 | 1831 | 610.3333333333334 | 152.5833333333333 | 5 | 6 | - | 5 | 6 | 11 | - | 2021-06-04 00:00:00 |  | Player's Pre-Match (Statistical) Data |  |  |  |  |  |  | Player's Post-Match Data
6 | 2 | 2021-06-11 00:00:00 | 131 | 161 | 145 | 437 | 145.6666666666667 | 136.6666666666667 | 820 | 24.33333333333334 | 9 |  |  | 2 | 24 | Team #1 | 609 | 534 |  | 1881 | 3712 | 618.6666666666666 | 154.6666666666667 | 7 | 4 |  | 12 | 10 | 22 | 1 | 2021-06-11 00:00:00 |  | Name | Scratch Pins | Total  Games |  | Average In League |  |  | Name | Match Series Pinfall | New Total  Games-to-Date | Match Average | New Total Pins-to-Date | # [NAME]YTD | New League Average-to-Date
9 | 3 | 2021-06-18 00:00:00 | 139 | 136 | 142 | 417 | 139 | 137.4444444444445 | 1237 | 4.555555555555543 | 1.555555555555543 |  |  | 3 | 36 | Team #7 | 617 | 549 |  | 1806 | 5518 | 613.1111111111111 | 153.2777777777778 | 0 | 11 | 8th | 12 | 21 | 33 | 1 | 2021-06-18 00:00:00 |  | Russ: | 1233 | 9 |  | 137 |  |  | Russ: | 458 | 12 | 152 | 1691 | 3 | 140
12 | 4 | 2021-06-25 00:00:00 | 151 | 158 | 148 | 457 | 152.3333333333333 | 141.1666666666667 | 1694 | 16.83333333333334 | 11.16666666666669 |  |  | 4 | 48 | Team #8 | 612 | 584 |  | 2003 | 7521 | 626.75 | 156.6875 | 11 | 0 |  | 23 | 21 | 44 | 1 | 2021-06-25 00:00:00 |  | Vince: | 1237 | 9 |  | 137 |  |  | Vince: | 457 | 12 | 152 | 1694 | 3 | 141
457 | 5 | 2021-07-02 00:00:00 |  |  |  |  | DNB | DNB | 1694 |  |  |  |  | 5 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2021-07-02 00:00:00 |  | Fred: | 1449 | 9 |  | 161 |  |  | Fred: | 513 | 12 | 171 | 1962 | 3 | 163
460 | 6 | 2021-07-09 00:00:00 |  |  |  |  | DNB | DNB | 1694 |  |  |  |  | 6 | 72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2021-07-09 00:00:00 |  | [NAME]: | 1599 | 9 |  | 177 |  |  | [NAME]: | 575 | 12 | 191 | 2174 | 3 | 181
463 | 7 | 2021-07-16 00:00:00 |  |  |  |  | DNB | DNB | 1694 |  |  |  |  | 7 | 84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2021-07-16 00:00:00 |  | Team's Pre-Match (Statistical) Data |  |  |  |  |  |  | Team's Post Match Data
466 | 8 | 2021-07-23 00:00:00 |  |  |  |  | DNB | DNB | 1694 |  |  |  |  | 8 | 96 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2021-07-23 00:00:00 |  | Pre-match Scratch  Pins: | 5518 | # of  Games: | 36 | Sum of  Averages: | 612 |  | Scratch Pins  in Match: | 2003 | Sum of  Averages  in Match: | 666 | Match Average: |  | 156
466 | 9 | 2021-07-30 00:00:00 |  |  |  |  | DNB | DNB | 1694 |  |  |  |  | 9 | 108 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2021-07-30 00:00:00 |  | Team Average Statistical: |  | 613.1111111111111 |  |  |  |  | New Scratch  Pins-to-Date: | 7521 | # of  Games: | 48 | New Team Average Statistical: |  | 624
469 | 10 | 2021-08-06 00:00:00 |  |  |  |  | DNB | DNB | 1694 |  |  |  |  | 10 | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2021-08-06 00:00:00
472 | 11 | 2021-08-13 00:00:00 |  |  |  |  | DNB | DNB | 1694 |  |  |  |  | 11 | 132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2021-08-13 00:00:00
475 | 12 | 2021-08-20 00:00:00 |  |  |  |  | DNB | DNB | 1694 |  |  |  |  | 12 | 144 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2021-08-20 00:00:00
478 | 13 | 2021-08-27 00:00:00 |  |  |  |  | DNB | DNB | 1694 |  |  |  |  | 13 | 156 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2021-08-27 00:00:00
---End Season--- | 14 | 2021-09-03 00:00:00 |  |  |  |  | DNB | DNB | 1694 |  |  |  |  | 14 | 168 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2021-09-03 00:00:00