Spreadsheet: 884842d1734107819-add-to-complex-formula-when-cell-does-not-meet-criteria-cell-remain-blank-sample
Sheet: Sheet1

First Name | Last Name | Date | Games |  |  | Total | Pins | # of Games | AVG | High Scratch Game | High Handicap Game | High Scratch Series | High Handicap Series | Award | Score | ID # | Position of Name in List | Full Name | Full Name List
[NAME] | Kidwell |  |  |  |  |  |  |  |  |  |  |  |  | High Scratch Game #1 |  |  |  |  |  | 1
 |  | 2024-11-04 00:00:00 | 154 | 100 | 108 |  |  |  |  |  |  |  |  | High Scratch Game #2 |  |  |  |  |  | 2
 |  | 2024-11-11 00:00:00 | 112 | 133 | 128 |  |  |  |  |  |  |  |  | High Scratch Game #3 |  |  |  |  |  | 3
 |  | 2024-11-18 00:00:00 | 108 | 112 | 153 |  |  |  |  |  |  |  |  | High Scratch Game #4 |  |  |  |  |  | 4
 |  | 2024-11-25 00:00:00 | 114 | 115 | 134 |  |  |  |  |  |  |  |  | High Scratch Game #5 |  |  |  |  |  | 5
 |  | 2024-12-02 00:00:00 | 134 | 156 | 189 |  |  |  |  |  |  |  |  | High Scratch Game #6 |  |  |  |  |  | 6
 |  | 2024-12-09 00:00:00 | ` |  |  |  |  |  |  |  |  |  |  | High Scratch Game #7 |  |  |  |  |  | 7
 |  | 2024-12-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Scratch Game #8 |  |  |  |  |  | 8
 |  | 2025-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Game #1 |  |  |  |  |  | 9
 |  | 2025-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Game #2 |  |  |  |  |  | 10
 |  | 2025-01-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Game #3 |  |  |  |  |  | 11
 |  | 2025-01-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Game #4 |  |  |  |  |  | 12
 |  | 2025-02-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Game #5 |  |  |  |  |  | 13
 |  | 2025-02-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Game #6 |  |  |  |  |  | 14
 |  | 2025-02-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Game #7 |  |  |  |  |  | 15
 |  | 2025-02-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Game #8 |  |  |  |  |  | 16
 |  | 2025-03-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Scratch Series #1 |  |  |  |  |  | 17
 |  | 2025-03-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Scratch Series #2 |  |  |  |  |  | 18
 |  | 2025-03-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Scratch Series #3 |  |  |  |  |  | 19
 |  | 2025-03-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Scratch Series #4 |  |  |  |  |  | 20
 |  | 2025-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Scratch Series #5 |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  | High Scratch Series #6 |  |  |  |  |  | 22
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | High Scratch Series #7 |  |  |  |  |  | 23
 |  | 2024-11-04 00:00:00 | 101 | 102 | 105 |  |  |  |  |  |  |  |  | High Scratch Series #8 |  |  |  |  |  | 24
 |  | 2024-11-11 00:00:00 | 107 | 110 | 108 |  |  |  |  |  |  |  |  | High Handicap Series #1 |  |  |  |  |  | 25
 |  | 2024-11-18 00:00:00 | 11 | 115 | 130 |  |  |  |  |  |  |  |  | High Handicap Series #2 |  |  |  |  |  | 26
 |  | 2024-11-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Series #3 |  |  |  |  |  | 27
 |  | 2024-12-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Series #4 |  |  |  |  |  | 28
 |  | 2024-12-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Series #5 |  |  |  |  |  | 29
 |  | 2024-12-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Series #6 |  |  |  |  |  | 30
 |  | 2025-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Series #7
 |  | 2025-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | High Handicap Series #8
 |  | 2025-01-20 00:00:00
 |  | 2025-01-27 00:00:00
 |  | 2025-02-03 00:00:00
 |  | 2025-02-10 00:00:00
 |  | 2025-02-17 00:00:00
 |  | 2025-02-24 00:00:00
 |  | 2025-03-03 00:00:00
 |  | 2025-03-10 00:00:00
 |  | 2025-03-17 00:00:00
 |  | 2025-03-24 00:00:00
 |  | 2025-03-31 00:00:00
[NAME] | Parker
 |  | 2024-11-04 00:00:00
 |  | 2024-11-11 00:00:00
 |  | 2024-11-18 00:00:00
 |  | 2024-11-25 00:00:00
 |  | 2024-12-02 00:00:00
 |  | 2024-12-09 00:00:00
 |  | 2024-12-16 00:00:00
 |  | 2025-01-06 00:00:00
 |  | 2025-01-13 00:00:00
 |  | 2025-01-20 00:00:00
 |  | 2025-01-27 00:00:00
 |  | 2025-02-03 00:00:00
 |  | 2025-02-10 00:00:00
 |  | 2025-02-17 00:00:00
 |  | 2025-02-24 00:00:00
 |  | 2025-03-03 00:00:00
 |  | 2025-03-10 00:00:00
 |  | 2025-03-17 00:00:00
 |  | 2025-03-24 00:00:00
 |  | 2025-03-31 00:00:00
[NAME] | Jones
 |  | 2024-11-04 00:00:00
 |  | 2024-11-11 00:00:00
 |  | 2024-11-18 00:00:00
 |  | 2024-11-25 00:00:00
 |  | 2024-12-02 00:00:00
 |  | 2024-12-09 00:00:00
 |  | 2024-12-16 00:00:00
 |  | 2025-01-06 00:00:00
 |  | 2025-01-13 00:00:00
 |  | 2025-01-20 00:00:00
 |  | 2025-01-27 00:00:00
 |  | 2025-02-03 00:00:00
 |  | 2025-02-10 00:00:00
 |  | 2025-02-17 00:00:00
 |  | 2025-02-24 00:00:00
 |  | 2025-03-03 00:00:00
 |  | 2025-03-10 00:00:00
 |  | 2025-03-17 00:00:00
 |  | 2025-03-24 00:00:00
 |  | 2025-03-31 00:00:00