Spreadsheet: 851205d1701431381-identify-single-occurances-in-list-of-data-sample-2-
Sheet: New Report

Client Code | Client Name | Assignment Type | [NAME] | Billed | WIP W/O
10GC1 | Company 1 | COMP Accounts Preparation | 10GC1/COMP Accounts Preparation | 81 | 81
10GC1 | Company 1 | COMP Accounts Preparation | 10GC1/COMP Accounts Preparation | 70 | 70
10GC1 | Company 1 | COMP Company Secretarial | 10GC1/COMP Company Secretarial | 35 | 35
10GC1 | Company 1 | COMP Payroll - Monthly | 10GC1/COMP Payroll - Monthly | 240.25 | 240.25
10GC1 | Company 1 | COMP Tax compliance | 10GC1/COMP Tax compliance | 15.5 | 15.5
10GC1 | Company 1 | COMP Tax compliance | 10GC1/COMP Tax compliance | 14.5 | 35.5
10GC1 | Company 1 | COMP VAT Consultancy | 10GC1/COMP VAT Consultancy | 155 | 155
10GC1 | Company 1 | CONS Business consulting | 10GC1/CONS Business consulting | 257 | 257
10GC1 | Company 1 | CONS MIS | 10GC1/CONS MIS | 63.5 | 63.5
10GC1 | Company 1 | CONS MIS | 10GC1/CONS MIS | 48 | 52.81
121C1 | Company 2 | COMP Accounts Preparation | 121C1/COMP Accounts Preparation | 1485 | 2241.5
121C1 | Company 2 | COMP Accounts Preparation | 121C1/COMP Accounts Preparation | 0 | 534
121C1 | Company 2 | COMP Company Secretarial | 121C1/COMP Company Secretarial | 0 | 22
121C1 | Company 2 | COMP Corporation Tax | 121C1/COMP Corporation Tax | 0 | 6
1STA1 | Company 3 | COMP Accounts Preparation | 1STA1/COMP Accounts Preparation | 1585 | 1094.57
1STA1 | Company 3 | COMP Company Secretarial | 1STA1/COMP Company Secretarial | 35 | 20
1STA1 | Company 3 | COMP Corporation Tax | 1STA1/COMP Corporation Tax | 0 | 18
22CH1 | Company 3 | COMP Accounts Preparation | 22CH1/COMP Accounts Preparation | 190 | 190
22PO1 | Company 4 | COMP Payroll - Monthly | 22PO1/CONS Corporate finance | 5985 | 5985
32HI1 | Company 5 | COMP Accounts Preparation | 32HI1/COMP Accounts Preparation | 1777 | 5346
32HI1 | Company 5 | COMP Company Secretarial | 32HI1/COMP Company Secretarial | 146 | 146
32HI1 | Company 5 | COMP Corporation Tax | 32HI1/COMP Corporation Tax | 285 | 290.5
32HI1 | Company 5 | CONS Business consulting | 32HI1/CONS Business consulting | 177 | 241
3KIN1 | Company 6 | COMP Accounts Preparation | 3KIN1/COMP Accounts Preparation | 485 | 521
3KIN1 | Company 6 | COMP Accounts Preparation | 3KIN1/COMP Accounts Preparation | 0 | 69.5
3KIN1 | Company 6 | COMP Company Secretarial | 3KIN1/COMP Company Secretarial | 185 | 229.95
42AL1 | Company 7 | COMP Accounts Preparation | 42AL1/COMP Accounts Preparation | 0 | 87
42AL1 | Company 7 | COMP Accounts Preparation | 42AL1/COMP Accounts Preparation | 35 | 58
42AL1 | Company 7 | COMP Company Secretarial | 42AL1/COMP Company Secretarial | 15 | 23.5
42AL1 | Company 7 | CONS Corporate finance | 42AL1/CONS Corporate finance | 0 | -10
42AL1 | Company 7 | CONS Corporate finance | 42AL1/CONS Corporate finance | 10 | 10
43RO1 | Company 8 | COMP Accounts Preparation | 43RO1/COMP Accounts Preparation | 95 | 44
43RO1 | Company 8 | COMP Accounts Preparation | 43RO1/COMP Accounts Preparation | 170 | 220
43RO1 | Company 8 | COMP Company Secretarial | 43RO1/COMP Company Secretarial | 0 | 45
43RO1 | Company 8 | COMP Company Secretarial | 43RO1/COMP Company Secretarial | 0 | 14
43RO1 | Company 8 | COMP P11D | 43RO1/COMP P11D | 0 | 6
4EDG1 | Company 9 | COMP Accounts Preparation | 4EDG1/COMP Accounts Preparation | 0 | 519.5
4EDG1 | Company 9 | COMP Accounts Preparation | 4EDG1/COMP Accounts Preparation | 1685 | 2585
4EDG1CF | Company 10 | CONS Corporate finance | 4EDG1CF/CONS Corporate finance | 0 | 0
4EDG1CF | Company 10 | CONS Corporate finance | 4EDG1CF/CONS Corporate finance | 0 | 0
4EDG1CF | Company 10 | CONS Corporate finance | 4EDG1CF/CONS Corporate finance | 1485 | 2193
TEST1 | TEST Limited | COMP Payroll - Monthly | TEST1/COMP Payroll - monthly | 1785 | 0