Spreadsheet: 847262d1698273562-please-help-clean-up-the-false-statements-in-my-worksheet-example
Sheet: Sheet1

Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column I | Column J | Column K | Player 1 | Player 1 Desired Output | Player 2 | Player 2 Desired output | Player 3 | Player 3 Desired output
HES | 9:30 | Samantha | 161.57 | 158.94 | 159.94 | 160.21 | 160.3 | 160.11 | 163.755 | 157.665
HES | 10:00 | Samantha | 160.33 | 158.64 | 159.92 | 160.08 | 160.5 | 159.67 | 161.245 | 156.895
HES | 11:00 | Samantha | 159.94 | 155 | 158.31 | 159.93 | 160.79 | 159.07 | 161.225 | 156.875 |  | 156.88
HES | 12:00 | Samantha | 158.44 | 156.76 | 157.07 | 159.55 | 161.49 | 157.62
HES | 13:00 | Samantha | 157.4 | 156.55 | 157.01 | 159.12 | 161.73 | 156.52
HES | 14:00 | Samantha
HES | 15:00 | Samantha
JAZZ | 9:30 | Samantha | 137.37 | 132.69 | 133.91 | 136.1 | 139.29 | 132.91 | 139.526 | 135.214 |  | 135.21
JAZZ | 10:00 | Samantha | 134.8 | 133 | 134.26 | 135.28 | 138.62 | 131.93 | 134.824 | 131.744
JAZZ | 11:00 | Samantha | 135.9 | 133.74 | 135.57 | 135.18 | 138.18 | 132.19 | 135.124 | 132.044
JAZZ | 12:00 | Samantha | 137.39 | 135.61 | 136 | 135.47 | 138.34 | 132.59
JAZZ | 13:00 | Samantha | 136.69 | 134.28 | 135.66 | 135.47 | 138.19 | 132.75
JAZZ | 14:00 | Samantha | 135.94 | 134.71 | 135.39 | 135.45 | 138.09 | 132.81
JAZZ | 15:00 | Samantha | 135.71 | 133.49 | 133.53 | 135.23 | 137.79 | 132.66
SPWR | 9:30 | Bodhi | 5.11 | 4.73 | 4.97 | 4.95 | 4.99 | 4.9 | 5.23 | 4.67
SPWR | 10:00 | Bodhi | 5.18 | 4.82 | 4.83 | 4.97 | 5.03 | 4.9 | 5.09 | 4.69 |  | 5.09
SPWR | 11:00 | Bodhi | 4.93 | 4.79 | 4.92 | 4.83 | 4.93 | 4.8 | 4.95 | 4.55
SPWR | 12:00 | Bodhi | 5.09 | 4.9 | 5.09 | 4.95 | 5.07 | 4.83
SPWR | 13:00 | Bodhi | 5.17 | 5.04 | 5.12 | 4.96 | 5.11 | 4.81
SPWR | 14:00 | Bodhi | 5.14 | 5.03 | 5.07 | 4.97 | 5.12 | 4.82
SPWR | 15:00 | Bodhi | 5.13 | 5.04 | 5.08 | 4.99 | 5.16 | 4.83
ENPH | 9:30 | Bodhi | 103.88 | 97.52 | 101.42 | 100.24 | 101.05 | 99.44 | 103.69 | 95.43 |  | 103.69
ENPH | 10:00 | Bodhi | 103.98 | 98.45 | 98.9 | 100.54 | 101.47 | 99.61 | 103.16 | 97.26
ENPH | 11:00 | Bodhi | 99.61 | 97.27 | 98.42 | 100.11 | 102.06 | 98.16 | 100.52 | 94.62
ENPH | 12:00 | Bodhi | 99.6 | 98.24 | 99.42 | 99.97 | 101.97 | 97.97
ENPH | 13:00 | Bodhi | 100.94 | 98.44 | 99.19 | 99.95 | 101.86 | 98.05
ENPH | 14:00 | Bodhi | 99.23 | 97.85 | 98.96 | 99.82 | 101.85 | 97.8
ENPH | 15:00 | Bodhi | 99.41 | 98.07 | 98.87 | 99.7 | 101.69 | 97.71
AMX | 9:30 | Samantha | 16.84 | 16.52 | 16.82 | 16.75 | 16.76 | 16.74 | 17.0825 | 16.4175
AMX | 10:00 | Samantha | 16.97 | 16.8 | 16.86 | 16.83 | 16.95 | 16.71 | 16.9625 | 16.4875 |  |  |  | yes |  | 16.83
AMX | 11:00 | Samantha | 16.96 | 16.86 | 16.93 | 16.85 | 16.97 | 16.73 | 17.0025 | 16.5275
AMX | 12:00 | Samantha | 17.04 | 16.89 | 17.02 | 16.88 | 17.03 | 16.73
AMX | 13:00 | Samantha | 17.11 | 16.95 | 16.99 | 16.92 | 17.1 | 16.74
AMX | 14:00 | Samantha | 17 | 16.9 | 16.96 | 16.92 | 17.09 | 16.76
AMX | 15:00 | Samantha | 17.01 | 16.82 | 16.82 | 16.91 | 17.05 | 16.78
TSLA | 9:30 | Samantha | 230.61 | 222.8 | 223.73 | 226.28 | 227.49 | 225.06 | 231.986 | 218.014
TSLA | 10:00 | Samantha | 226.02 | 220.35 | 221.28 | 224.82 | 228.08 | 221.56 | 226.674 | 216.694
TSLA | 11:00 | Samantha | 222.4 | 218.67 | 221.17 | 223.71 | 228.43 | 219 | 224.274 | 214.294
TSLA | 12:00 | Samantha | 223.09 | 219.02 | 220.75 | 223.22 | 227.95 | 218.48
TSLA | 13:00 | Samantha | 222.49 | 219.5 | 220.04 | 222.95 | 227.64 | 218.26
TSLA | 14:00 | Samantha | 220.28 | 216.78 | 217.31 | 222.41 | 227.69 | 217.13 |  |  |  | 217.13
TSLA | 15:00 | Samantha | 221 | 217.16 | 220.1 | 221.95 | 227.48 | 216.42
SEDG | 9:30 | Bodhi | 83.5 | 72.37 | 82.03 | 78.43 | 81.22 | 75.65 | 80.878 | 71.16199999999999 |  | 80.88
SEDG | 10:00 | Bodhi | 85.39 | 79.81 | 80 | 80.06 | 84.66 | 75.45 | 84.13199999999999 | 77.192
SEDG | 11:00 | Bodhi | 80.64 | 77.76 | 79.93 | 79.9 | 84.15 | 75.66 | 82.082 | 75.142
SEDG | 12:00 | Bodhi
SEDG | 13:00 | Bodhi
SEDG | 14:00 | Bodhi
SEDG | 15:00 | Bodhi