Spreadsheet: 796570d1663353280-count-only-one-occurrences-based-on-multiple-criteria-book-2
Sheet: Original POST

Name | Date/Time | Date | Time | Pay Code | test for code | GOAL | Attempt |  |  | Date Range | 2022-07-04 00:00:00 | To | 2022-08-26 00:00:00
Doe, [NAME] | 2022-08-11 06:30:00 | 2022-08-11 00:00:00 | 06:30:00 | REG PAY
Doe, [NAME] | 2022-08-11 06:30:00 | 2022-08-11 00:00:00 | 06:30:00 | SHORT LUNCH |  |  |  |  |  | Name | Occurences | Goal
Doe, [NAME] | 2022-08-11 11:00:00 | 2022-08-11 00:00:00 | 11:00:00 | REG PAY |  | 1 |  |  |  | Doe, [NAME] |  | 12
Doe, [NAME] | 2022-08-12 05:45:00 | 2022-08-12 00:00:00 | 05:45:00 | REG PAY |  |  |  |  |  | [NAME], [NAME] |  | 16
Doe, [NAME] | 2022-08-12 05:45:00 | 2022-08-12 00:00:00 | 05:45:00 | SHORT LUNCH
Doe, [NAME] | 2022-08-12 13:15:00 | 2022-08-12 00:00:00 | 13:15:00 | OT PAY
Doe, [NAME] | 2022-08-12 13:15:00 | 2022-08-12 00:00:00 | 13:15:00 | REG PAY |  | 1 |  |  |  | Count one occurrence per day, per person of “REG PAY”, “ORIENT”, or “AGENCY”
Doe, [NAME] | 2022-08-15 05:46:00 | 2022-08-15 00:00:00 | 05:46:00 | LUNCH NP
Doe, [NAME] | 2022-08-15 05:46:00 | 2022-08-15 00:00:00 | 05:46:00 | REG PAY
Doe, [NAME] | 2022-08-15 11:15:00 | 2022-08-15 00:00:00 | 11:15:00 | LWL NO PAY
Doe, [NAME] | 2022-08-15 11:15:00 | 2022-08-15 00:00:00 | 11:15:00 | REG PAY |  | 1
Doe, [NAME] | 2022-08-16 06:41:00 | 2022-08-16 00:00:00 | 06:41:00 | REG PAY
Doe, [NAME] | 2022-08-16 06:41:00 | 2022-08-16 00:00:00 | 06:41:00 | SHORT LUNCH
Doe, [NAME] | 2022-08-16 12:04:00 | 2022-08-16 00:00:00 | 12:04:00 | LWL NO PAY
Doe, [NAME] | 2022-08-16 12:04:00 | 2022-08-16 00:00:00 | 12:04:00 | REG PAY |  | 1
Doe, [NAME] | 2022-08-17 05:49:00 | 2022-08-17 00:00:00 | 05:49:00 | REG PAY
Doe, [NAME] | 2022-08-17 05:49:00 | 2022-08-17 00:00:00 | 05:49:00 | SHORT LUNCH
Doe, [NAME] | 2022-08-17 11:07:00 | 2022-08-17 00:00:00 | 11:07:00 | OT PAY
Doe, [NAME] | 2022-08-17 11:07:00 | 2022-08-17 00:00:00 | 11:07:00 | REG PAY |  | 1
Doe, [NAME] | 2022-08-18 06:07:00 | 2022-08-18 00:00:00 | 06:07:00 | LUNCH NP
Doe, [NAME] | 2022-08-18 06:07:00 | 2022-08-18 00:00:00 | 06:07:00 | REG PAY
Doe, [NAME] | 2022-08-18 11:10:00 | 2022-08-18 00:00:00 | 11:10:00 | LWL NO PAY
Doe, [NAME] | 2022-08-18 11:10:00 | 2022-08-18 00:00:00 | 11:10:00 | REG PAY |  | 1
Doe, [NAME] | 2022-08-19 06:50:00 | 2022-08-19 00:00:00 | 06:50:00 | REG PAY
Doe, [NAME] | 2022-08-19 06:50:00 | 2022-08-19 00:00:00 | 06:50:00 | SHORT LUNCH
Doe, [NAME] | 2022-08-19 10:53:00 | 2022-08-19 00:00:00 | 10:53:00 | CALL PAY
Doe, [NAME] | 2022-08-19 10:53:00 | 2022-08-19 00:00:00 | 10:53:00 | OT PAY
Doe, [NAME] | 2022-08-19 10:53:00 | 2022-08-19 00:00:00 | 10:53:00 | REG PAY
Doe, [NAME] | 2022-08-19 14:20:00 | 2022-08-19 00:00:00 | 14:20:00 | [NAME] PREM |  | 1
Doe, [NAME] | 2022-08-20 06:00:00 | 2022-08-20 00:00:00 | 06:00:00 | [NAME] PREM
Doe, [NAME] | 2022-08-21 06:00:00 | 2022-08-21 00:00:00 | 06:00:00 | [NAME] PREM
Doe, [NAME] | 2022-08-22 05:49:00 | 2022-08-22 00:00:00 | 05:49:00 | REG PAY
Doe, [NAME] | 2022-08-22 05:49:00 | 2022-08-22 00:00:00 | 05:49:00 | SHORT LUNCH
Doe, [NAME] | 2022-08-22 11:54:00 | 2022-08-22 00:00:00 | 11:54:00 | OT PAY
Doe, [NAME] | 2022-08-22 11:54:00 | 2022-08-22 00:00:00 | 11:54:00 | REG PAY |  | 1
Doe, [NAME] | 2022-08-23 05:50:00 | 2022-08-23 00:00:00 | 05:50:00 | REG PAY
Doe, [NAME] | 2022-08-23 05:50:00 | 2022-08-23 00:00:00 | 05:50:00 | SHORT LUNCH
Doe, [NAME] | 2022-08-23 10:55:00 | 2022-08-23 00:00:00 | 10:55:00 | OT PAY
Doe, [NAME] | 2022-08-23 10:55:00 | 2022-08-23 00:00:00 | 10:55:00 | REG PAY |  | 1
Doe, [NAME] | 2022-08-24 05:52:00 | 2022-08-24 00:00:00 | 05:52:00 | REG PAY
Doe, [NAME] | 2022-08-24 05:52:00 | 2022-08-24 00:00:00 | 05:52:00 | SHORT LUNCH
Doe, [NAME] | 2022-08-24 12:12:00 | 2022-08-24 00:00:00 | 12:12:00 | OT PAY
Doe, [NAME] | 2022-08-24 12:12:00 | 2022-08-24 00:00:00 | 12:12:00 | REG PAY |  | 1
Doe, [NAME] | 2022-08-25 06:30:00 | 2022-08-25 00:00:00 | 06:30:00 | REG PAY
Doe, [NAME] | 2022-08-25 06:30:00 | 2022-08-25 00:00:00 | 06:30:00 | SHORT LUNCH
Doe, [NAME] | 2022-08-25 12:16:00 | 2022-08-25 00:00:00 | 12:16:00 | LWL NO PAY
Doe, [NAME] | 2022-08-25 12:16:00 | 2022-08-25 00:00:00 | 12:16:00 | REG PAY
Doe, [NAME] | 2022-08-25 14:15:00 | 2022-08-25 00:00:00 | 14:15:00 | [NAME] PREM |  | 1
Doe, [NAME] | 2022-08-26 05:38:00 | 2022-08-26 00:00:00 | 05:38:00 | LUNCH NP
Doe, [NAME] | 2022-08-26 05:38:00 | 2022-08-26 00:00:00 | 05:38:00 | REG PAY
Doe, [NAME] | 2022-08-26 13:15:00 | 2022-08-26 00:00:00 | 13:15:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-07-04 07:00:00 | 2022-07-04 00:00:00 | 07:00:00 | PTO
[NAME], [NAME] | 2022-07-06 15:30:00 | 2022-07-06 00:00:00 | 15:30:00 | [NAME] PREM
[NAME], [NAME] | 2022-07-11 15:30:00 | 2022-07-11 00:00:00 | 15:30:00 | [NAME] PREM
[NAME], [NAME] | 2022-07-13 15:00:00 | 2022-07-13 00:00:00 | 15:00:00 | [NAME] PREM
[NAME], [NAME] | 2022-07-15 07:00:00 | 2022-07-15 00:00:00 | 07:00:00 | LWL PTO
[NAME], [NAME] | 2022-07-18 07:00:00 | 2022-07-18 00:00:00 | 07:00:00 | PTO
[NAME], [NAME] | 2022-07-19 07:00:00 | 2022-07-19 00:00:00 | 07:00:00 | PTO
[NAME], [NAME] | 2022-07-20 07:00:00 | 2022-07-20 00:00:00 | 07:00:00 | PTO
[NAME], [NAME] | 2022-07-21 07:00:00 | 2022-07-21 00:00:00 | 07:00:00 | PTO
[NAME], [NAME] | 2022-07-22 07:00:00 | 2022-07-22 00:00:00 | 07:00:00 | PTO
[NAME], [NAME] | 2022-07-25 07:00:00 | 2022-07-25 00:00:00 | 07:00:00 | PTO
[NAME], [NAME] | 2022-07-30 07:00:00 | 2022-07-30 00:00:00 | 07:00:00 | [NAME] PREM
[NAME], [NAME] | 2022-08-01 07:00:00 | 2022-08-01 00:00:00 | 07:00:00 | LWL PTO
[NAME], [NAME] | 2022-08-02 07:00:00 | 2022-08-02 00:00:00 | 07:00:00 | LWL PTO
[NAME], [NAME] | 2022-08-03 06:35:00 | 2022-08-03 00:00:00 | 06:35:00 | REG PAY
[NAME], [NAME] | 2022-08-03 06:35:00 | 2022-08-03 00:00:00 | 06:35:00 | SHORT LUNCH
[NAME], [NAME] | 2022-08-03 11:35:00 | 2022-08-03 00:00:00 | 11:35:00 | OT PAY
[NAME], [NAME] | 2022-08-03 11:35:00 | 2022-08-03 00:00:00 | 11:35:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-04 06:34:00 | 2022-08-04 00:00:00 | 06:34:00 | CALL PAY
[NAME], [NAME] | 2022-08-04 06:34:00 | 2022-08-04 00:00:00 | 06:34:00 | OT PAY
[NAME], [NAME] | 2022-08-04 06:34:00 | 2022-08-04 00:00:00 | 06:34:00 | REG PAY
[NAME], [NAME] | 2022-08-04 14:34:00 | 2022-08-04 00:00:00 | 14:34:00 | [NAME] PREM
[NAME], [NAME] | 2022-08-04 14:34:00 | 2022-08-04 00:00:00 | 14:34:00 | [NAME] PREM |  | 1
[NAME], [NAME] | 2022-08-05 00:00:00 | 2022-08-05 00:00:00 | 00:00:00 | CALL MIN
[NAME], [NAME] | 2022-08-05 00:00:00 | 2022-08-05 00:00:00 | 00:00:00 | CALL PAY
[NAME], [NAME] | 2022-08-05 00:00:00 | 2022-08-05 00:00:00 | 00:00:00 | [NAME]
[NAME], [NAME] | 2022-08-05 06:43:00 | 2022-08-05 00:00:00 | 06:43:00 | LUNCH NP
[NAME], [NAME] | 2022-08-05 06:43:00 | 2022-08-05 00:00:00 | 06:43:00 | REG PAY
[NAME], [NAME] | 2022-08-05 12:05:00 | 2022-08-05 00:00:00 | 12:05:00 | OT PAY
[NAME], [NAME] | 2022-08-05 12:05:00 | 2022-08-05 00:00:00 | 12:05:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-08 06:44:00 | 2022-08-08 00:00:00 | 06:44:00 | LUNCH NP
[NAME], [NAME] | 2022-08-08 06:44:00 | 2022-08-08 00:00:00 | 06:44:00 | REG PAY
[NAME], [NAME] | 2022-08-08 11:29:00 | 2022-08-08 00:00:00 | 11:29:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-10 06:31:00 | 2022-08-10 00:00:00 | 06:31:00 | LUNCH NP
[NAME], [NAME] | 2022-08-10 06:31:00 | 2022-08-10 00:00:00 | 06:31:00 | REG PAY
[NAME], [NAME] | 2022-08-10 11:39:00 | 2022-08-10 00:00:00 | 11:39:00 | OT PAY
[NAME], [NAME] | 2022-08-10 11:39:00 | 2022-08-10 00:00:00 | 11:39:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-11 06:37:00 | 2022-08-11 00:00:00 | 06:37:00 | OT PAY
[NAME], [NAME] | 2022-08-11 06:37:00 | 2022-08-11 00:00:00 | 06:37:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-12 06:19:00 | 2022-08-12 00:00:00 | 06:19:00 | OT PAY
[NAME], [NAME] | 2022-08-12 06:19:00 | 2022-08-12 00:00:00 | 06:19:00 | REG PAY
[NAME], [NAME] | 2022-08-12 16:00:00 | 2022-08-12 00:00:00 | 16:00:00 | [NAME] PREM
[NAME], [NAME] | 2022-08-12 16:18:00 | 2022-08-12 00:00:00 | 16:18:00 | CALL MIN
[NAME], [NAME] | 2022-08-12 16:18:00 | 2022-08-12 00:00:00 | 16:18:00 | CALL PAY
[NAME], [NAME] | 2022-08-12 16:18:00 | 2022-08-12 00:00:00 | 16:18:00 | [NAME] |  | 1
[NAME], [NAME] | 2022-08-13 07:00:00 | 2022-08-13 00:00:00 | 07:00:00 | [NAME] PREM
[NAME], [NAME] | 2022-08-13 07:00:00 | 2022-08-13 00:00:00 | 07:00:00 | [NAME] PREM
[NAME], [NAME] | 2022-08-13 11:51:00 | 2022-08-13 00:00:00 | 11:51:00 | CALL PAY
[NAME], [NAME] | 2022-08-13 11:51:00 | 2022-08-13 00:00:00 | 11:51:00 | T2 WKND DIF
[NAME], [NAME] | 2022-08-15 06:27:00 | 2022-08-15 00:00:00 | 06:27:00 | LUNCH NP
[NAME], [NAME] | 2022-08-15 06:27:00 | 2022-08-15 00:00:00 | 06:27:00 | REG PAY
[NAME], [NAME] | 2022-08-15 12:02:00 | 2022-08-15 00:00:00 | 12:02:00 | OT PAY
[NAME], [NAME] | 2022-08-15 12:02:00 | 2022-08-15 00:00:00 | 12:02:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-16 06:48:00 | 2022-08-16 00:00:00 | 06:48:00 | OT PAY
[NAME], [NAME] | 2022-08-16 06:48:00 | 2022-08-16 00:00:00 | 06:48:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-17 06:28:00 | 2022-08-17 00:00:00 | 06:28:00 | LUNCH NP
[NAME], [NAME] | 2022-08-17 06:28:00 | 2022-08-17 00:00:00 | 06:28:00 | REG PAY
[NAME], [NAME] | 2022-08-17 12:35:00 | 2022-08-17 00:00:00 | 12:35:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-18 06:34:00 | 2022-08-18 00:00:00 | 06:34:00 | OT PAY
[NAME], [NAME] | 2022-08-18 06:34:00 | 2022-08-18 00:00:00 | 06:34:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-19 07:31:00 | 2022-08-19 00:00:00 | 07:31:00 | LWL NO PAY
[NAME], [NAME] | 2022-08-19 07:31:00 | 2022-08-19 00:00:00 | 07:31:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-21 07:00:00 | 2022-08-21 00:00:00 | 07:00:00 | [NAME] PREM
[NAME], [NAME] | 2022-08-22 07:00:00 | 2022-08-22 00:00:00 | 07:00:00 | PTO
[NAME], [NAME] | 2022-08-23 06:32:00 | 2022-08-23 00:00:00 | 06:32:00 | REG PAY
[NAME], [NAME] | 2022-08-23 06:32:00 | 2022-08-23 00:00:00 | 06:32:00 | SHORT LUNCH
[NAME], [NAME] | 2022-08-23 11:56:00 | 2022-08-23 00:00:00 | 11:56:00 | OT PAY
[NAME], [NAME] | 2022-08-23 11:56:00 | 2022-08-23 00:00:00 | 11:56:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-24 06:39:00 | 2022-08-24 00:00:00 | 06:39:00 | OT PAY
[NAME], [NAME] | 2022-08-24 06:39:00 | 2022-08-24 00:00:00 | 06:39:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-25 06:40:00 | 2022-08-25 00:00:00 | 06:40:00 | LUNCH NP
[NAME], [NAME] | 2022-08-25 06:40:00 | 2022-08-25 00:00:00 | 06:40:00 | REG PAY
[NAME], [NAME] | 2022-08-25 11:32:00 | 2022-08-25 00:00:00 | 11:32:00 | LWL NO PAY
[NAME], [NAME] | 2022-08-25 11:32:00 | 2022-08-25 00:00:00 | 11:32:00 | REG PAY |  | 1
[NAME], [NAME] | 2022-08-26 06:34:00 | 2022-08-26 00:00:00 | 06:34:00 | OT PAY
[NAME], [NAME] | 2022-08-26 06:34:00 | 2022-08-26 00:00:00 | 06:34:00 | REG PAY
[NAME], [NAME] | 2022-08-26 15:30:00 | 2022-08-26 00:00:00 | 15:30:00 | [NAME] PREM |  | 1