Spreadsheet: 776877d1649956012-consolidate-and-add-data-with-unique-sort-and-various-other-functions-consolidator
Sheet: Tool-CWOP LE

Input Data in the Green areas, results populate in Blue, consolidated in Yellow
NOTE:  [NAME] are protected.  Unprotect sheet to change them.  No password.
 |  |  | 4116 Amount | 836219.5
Invoice | Date | Location | Region | Amount |  |  | MM/YY | DEPTID | PROGRAM | PROJECT_ID | APPROP | PCA | AY | ACCOUNT | ACCOUNT_DESCR | Amount | Description
 |  |  |  |  | Total
11470 | 2022-03-20 00:00:00 | Victoria | 8B or 08(8b invalid for FC) | 56339 |  |  |  |  |  |  |  | 03040 |  | 7299CW | Security for CWOP
11471 | 2022-03-20 00:00:00 | Midland | 09 | 3986.5 |  |  | 03/22 | 09CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 3986.5 | 11471
11473 | 2022-03-20 00:00:00 | Waxahachie | 3E | 30256 |  |  | 03/22 | 3ECDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 30256 | 11473
11475 | 2022-03-20 00:00:00 | El Paso | 10 | 13572 |  |  | 03/22 | 10CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 13572 | 11475
11479 | 2022-03-20 00:00:00 | Temple | 07 | 18848 |  |  | 03/22 | 07CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 18848 | 11479
11480 | 2022-03-20 00:00:00 | Atlanta | 04 | 11532 |  |  | 03/22 | 04CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 11532 | 11480
11481 | 2022-03-20 00:00:00 | Pearland | 6B (Invalid for FC; use 6A) | 36252 |  |  | 03/22 | 6ACDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 36252 | 11481
11482 | 2022-03-20 00:00:00 | Lufkin | 05 | 35563 |  |  | 03/22 | 05CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 35563 | 11482
11494 | 2022-03-20 00:00:00 | Houston | 6A | 31535 |  |  | 03/22 | 6ACDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 31535 | 11494
11495 | 2022-03-20 00:00:00 | Corpus Christi | 11 | 46375 |  |  | 03/22 | 11CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 46375 | 11495
11511 | 2022-03-27 00:00:00 | Victoria | 8B or 08(8b invalid for FC) | 63361.5 |  |  | 03/22 | 08CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 63361.5 | 11511
11514 | 2022-03-27 00:00:00 | El Paso | 10 | 8584 |  |  | 03/22 | 10CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 8584 | 11514
11516 | 2022-03-27 00:00:00 | Victoria | 8B or 08(8b invalid for FC) | 32116 |  |  | 03/22 | 08CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 32116 | 11516
11517 | 2022-03-27 00:00:00 | Pearland | 6B (Invalid for FC; use 6A) | 38319 |  |  | 03/22 | 6ACDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 38319 | 11517
11518 | 2022-03-27 00:00:00 | Corpus Christi | 11 | 28381.5 |  |  | 03/22 | 11CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 28381.5 | 11518
11523 | 2022-03-27 00:00:00 | Atlanta | 04 | 19716 |  |  | 03/22 | 04CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 19716 | 11523
11524 | 2022-03-27 00:00:00 | Lufkin | 05 | 35616 |  |  | 03/22 | 05CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 35616 | 11524
11525 | 2022-03-27 00:00:00 | Temple | 07 | 21111 |  |  | 03/22 | 07CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 21111 | 11525
11527 | 2022-03-27 00:00:00 | Houston | 6A | 36305 |  |  | 03/22 | 6ACDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 36305 | 11527
11545 | 2022-04-03 00:00:00 | Victoria | 8B or 08(8b invalid for FC) | 71788.5 |  |  | 04/22 | 08CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 71788.5 | 11545
11547 | 2022-04-03 00:00:00 | Houston | 6A | 33602 |  |  | 04/22 | 6ACDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 33602 | 11547
11548 | 2022-04-03 00:00:00 | Pearland | 6B (Invalid for FC; use 6A) | 24698 |  |  | 04/22 | 6ACDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 24698 | 11548
11554 | 2022-04-03 00:00:00 | Corpus Christi | 11 | 24512.5 |  |  | 04/22 | 11CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 24512.5 | 11554
11555 | 2022-04-03 00:00:00 | Waxahachie | 3E | 25668 |  |  | 04/22 | 3ECDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 25668 | 11555
11559 | 2022-04-03 00:00:00 | Atlanta | 04 | 26846 |  |  | 04/22 | 04CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 26846 | 11559
11560 | 2022-04-03 00:00:00 | Temple | 07 | 25730 |  |  | 04/22 | 07CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 25730 | 11560
11562 | 2022-04-03 00:00:00 | Lufkin | 05 | 35616 |  |  | 04/22 | 05CDDOTH | 110CW | 4500GR | 13040 |  | 2022 |  |  | 35616 | 11562
 |  |  |  |  |  |  | Consolidator |  |  |  |  |  |  |  |  | Amount | Description
 |  |  |  |  |  |  | MM/YY | DEPTID | PROGRAM | PROJECT_ID | APPROP | PCA | AY | ACCOUNT | ACCOUNT_DESCR
 |  |  |  |  |  |  |  | 04CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP
 |  |  |  |  |  |  | 04/22 | 04CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 26846
 |  |  |  |  |  |  | 03/22 | 05CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 71179
 |  |  |  |  |  |  | 04/22 | 05CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 35616
 |  |  |  |  |  |  | 03/22 | 07CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 39959
 |  |  |  |  |  |  | 04/22 | 07CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 25730
 |  |  |  |  |  |  | 03/22 | 08CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 151816.5
 |  |  |  |  |  |  | 04/22 | 08CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 71788.5
 |  |  |  |  |  |  | 03/22 | 09CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 3986.5
 |  |  |  |  |  |  | 03/22 | 10CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 22156
 |  |  |  |  |  |  | 03/22 | 11CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 74756.5
 |  |  |  |  |  |  | 04/22 | 11CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 24512.5
 |  |  |  |  |  |  | 03/22 | 3ECDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 30256
 |  |  |  |  |  |  | 04/22 | 3ECDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 25668
 |  |  |  |  |  |  | 03/22 | 6ACDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 142411
 |  |  |  |  |  |  | 04/22 | 6ACDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | Security for CWOP | 58300
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 03/22 | 04CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 31248
 |  |  |  |  |  |  | 04/22 | 04CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 26846
 |  |  |  |  |  |  | 03/22 | 05CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 71179
 |  |  |  |  |  |  | 04/22 | 05CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 35616
 |  |  |  |  |  |  | 03/22 | 07CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 39959
 |  |  |  |  |  |  | 04/22 | 07CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 25730
 |  |  |  |  |  |  | 03/22 | 08CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 151816.5
 |  |  |  |  |  |  | 04/22 | 08CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 71788.5
 |  |  |  |  |  |  | 03/22 | 09CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 3986.5
 |  |  |  |  |  |  | 03/22 | 10CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 22156
 |  |  |  |  |  |  | 03/22 | 11CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 74756.5
 |  |  |  |  |  |  | 04/22 | 11CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 24512.5
 |  |  |  |  |  |  | 03/22 | 3ECDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 30256
 |  |  |  |  |  |  | 04/22 | 3ECDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 25668
 |  |  |  |  |  |  | 03/22 | 6ACDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 142411
 |  |  |  |  |  |  | 04/22 | 6ACDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW |  | 58300
 |  |  |  |  |  |  |  | 04CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 31248
 |  |  |  |  |  |  | 04/22 | 04CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 26846
 |  |  |  |  |  |  | 03/22 | 05CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 71179
 |  |  |  |  |  |  | 04/22 | 05CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 35616
 |  |  |  |  |  |  | 03/22 | 07CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 39959
 |  |  |  |  |  |  | 04/22 | 07CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 25730
 |  |  |  |  |  |  | 03/22 | 08CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 151816.5
 |  |  |  |  |  |  | 04/22 | 08CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 71788.5
 |  |  |  |  |  |  | 03/22 | 09CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 3986.5
 |  |  |  |  |  |  | 03/22 | 10CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 22156
 |  |  |  |  |  |  | 03/22 | 11CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 74756.5
 |  |  |  |  |  |  | 04/22 | 11CDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 24512.5
 |  |  |  |  |  |  | 03/22 | 3ECDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 30256
 |  |  |  |  |  |  | 04/22 | 3ECDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 25668
 |  |  |  |  |  |  | 03/22 | 6ACDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 142411
 |  |  |  |  |  |  | 04/22 | 6ACDDOTH | 110CW | 4500GR | 13040 | 03040 | 2022 | 7299CW | SecurityforCWOP | 58300