Spreadsheet: 849002d1699568063-stuck-on-index-match-is-there-a-better-way-without-vba-sampleindex-1-
Sheet: Sheet1

 | CASE REPLIES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inbound Calls |  | Case Replies | Case Replies | Customers Helped / Cases Solved |  | ABC |  | Claims |  | XYZ
Week | Team Total | Goal # | Goal (%) | Actual (#) | Goal (%) Actual | % of Quota (#) | % of Quota (%) | Higher % of Quota |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal %
2023-10-16 00:00:00 | 167 |  |  | 12 | 0.0718562874251497 | 0.0718562874251497 | 1.026518391787853 | 1.026518391787853 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-16 00:00:00 | 5 | 7 | 6 | 8 | 7 | 9 | 8 | 10 | 9 | 11 | 10 | 12
2023-10-23 00:00:00 | 169 | 7 | 9 | 13 | 0.07692307692307693 | 0.07692307692307693 | 0.9615384615384616 | 0.9615384615384616 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-23 00:00:00 | 6 | 8 | 7 | 9 | 8 | 10 | 9 | 11 | 10 | 12 | 11 | 13
2023-10-30 00:00:00 | 171 | 8 | 10 | 14 | 0.08187134502923976 | 0.08187134502923976 | 0.9096816114359974 | 0.9096816114359974 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-30 00:00:00 | 7 | 9 | 8 | 10 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14
2023-11-06 00:00:00 | 173 | 9 | 11 | 15 | 0.08670520231213873 | 0.08670520231213873 | 0.8670520231213872 | 0.8670520231213872 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-06 00:00:00 | 8 | 10 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14 | 13 | 15
2023-11-13 00:00:00 |  | 10 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-13 00:00:00 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14 | 13 | 15 | 14 | 16
2023-11-20 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-20 00:00:00
2023-11-27 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-27 00:00:00
2023-12-04 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-04 00:00:00
2023-12-11 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-11 00:00:00
2023-12-18 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-18 00:00:00
2023-12-25 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-25 00:00:00