Spreadsheet: 741770d1627321546-countifs-unique-value-example
Sheet: Sheet1

Job # | 1320148.
Unique Individuals
payEnd | Description | FullName | PRCo | Job | Phase | PREndDate | Employee | EarnCode | Hours | Amt | fullAmt | Rate | payType | FUTA | FICA | SUTA | WorkersComp | GLIns | ExcessSuta | Fringes | Pension
2021-07-20 00:00:00 | - | Smith, [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 103602 | 1 | 2 | 85.7 | 114.86 | 42.85 | ST |  | 6.53 |  | 8.78 | 4.07 | 9.78 | 50.3
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 100010 | 1 | 8 | 319.76 | 428.69 | 39.97 | ST |  | 24.47 |  | 32.74 | 15.19 | 36.53 | 201.2
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 100010 | 1 | 8 | 319.76 | 428.69 | 39.97 | ST |  | 24.47 |  | 32.74 | 15.19 | 36.53 | 201.2
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 100010 | 1 | 8 | 319.76 | 428.69 | 39.97 | ST |  | 24.47 |  | 32.74 | 15.19 | 36.53 | 201.2
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 100010 | 1 | 8 | 319.76 | 428.69 | 39.97 | ST |  | 24.47 |  | 32.74 | 15.19 | 36.53 | 201.2
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 100010 | 1 | 8 | 319.76 | 428.64 | 39.97 | ST |  | 24.43 |  | 32.76 | 15.18 | 36.51 | 201.2
2021-07-20 00:00:00 | - | Thompson, Jared | 10 | 1320148. | 6 Field Labor | 44397 | 100022 | 2 | 5 | 321.38 | 430.85 | 64.275 | OT |  | 24.58 |  | 32.91 | 15.27 | 36.71 | 125.75
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 106240 | 1 | 8 | 147.92 | 199.2 | 18.49 | ST | 0.89 | 11.31 |  | 15.15 | 7.03 | 16.9 | 91.84
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 106240 | 1 | 8 | 147.92 | 199.2 | 18.49 | ST | 0.89 | 11.31 |  | 15.15 | 7.03 | 16.9 | 91.84
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 106240 | 1 | 8 | 147.92 | 199.2 | 18.49 | ST | 0.89 | 11.31 |  | 15.15 | 7.03 | 16.9 | 91.84
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 106240 | 1 | 8 | 147.92 | 199.2 | 18.49 | ST | 0.89 | 11.31 |  | 15.15 | 7.03 | 16.9 | 91.84
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 106240 | 1 | 8 | 147.92 | 199.18 | 18.49 | ST | 0.88 | 11.34 |  | 15.14 | 7.01 | 16.89 | 91.84
2021-07-20 00:00:00 | - | Mohammed, J | 10 | 1320148. | 6 Field Labor | 44397 | 106656 | 1 | 8 | 177.44 | 237.93 | 22.18 | ST |  | 13.6 |  | 18.17 | 8.42 | 20.3 | 91.84
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 101240 | 1 | 4 | 178.84 | 239.75 | 44.71 | ST |  | 13.68 |  | 18.31 | 8.49 | 20.43 | 120
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 102388 | 1 | 8 | 357.6 | 479.42 | 44.7 | ST |  | 27.36 |  | 36.62 | 16.99 | 40.85 | 201.2
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 102388 | 1 | 8 | 357.6 | 479.42 | 44.7 | ST |  | 27.36 |  | 36.62 | 16.99 | 40.85 | 201.2
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 102388 | 1 | 8 | 357.6 | 479.42 | 44.7 | ST |  | 27.36 |  | 36.62 | 16.99 | 40.85 | 201.2
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 102388 | 1 | 8 | 357.6 | 479.42 | 44.7 | ST |  | 27.36 |  | 36.62 | 16.99 | 40.85 | 201.2
2021-07-20 00:00:00 | - | [NAME], [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 106656 | 1 | 8 | 177.44 | 237.87 | 22.18 | ST |  | 13.57 |  | 18.17 | 8.43 | 20.26 | 91.84
2021-07-20 00:00:00 | - | Fitz, [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 100022 | 1 | 8 | 342.8 | 459.56 | 42.85 | ST |  | 26.22 |  | 35.1 | 16.28 | 39.16 | 201.2
2021-07-20 00:00:00 | - | Fitz, [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 100022 | 1 | 8 | 342.8 | 459.56 | 42.85 | ST |  | 26.22 |  | 35.1 | 16.28 | 39.16 | 201.2
2021-07-20 00:00:00 | - | Fitz, [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 100022 | 1 | 8 | 342.8 | 459.56 | 42.85 | ST |  | 26.22 |  | 35.1 | 16.28 | 39.16 | 201.2
2021-07-20 00:00:00 | - | Fitz, [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 100022 | 1 | 8 | 342.8 | 459.56 | 42.85 | ST |  | 26.22 |  | 35.1 | 16.28 | 39.16 | 201.2
2021-07-20 00:00:00 | - | Fitz, [NAME] | 10 | 1320148. | 6 Field Labor | 44397 | 100022 | 1 | 8 | 342.8 | 459.59 | 42.85 | ST |  | 26.24 |  | 35.11 | 16.29 | 39.15 | 201.2