Spreadsheet: 782692d1654186060-updated-splitting-a-lookup-value-among-several-rows-and-conditional-formatting-based-sold-data-example-1
Sheet: Sold Data

Date Sold | Cust # | Equip ID | Serial Number | Sold To Customer | Ship To Customer | Invoice # | Receivable | Cust Pd Date | Amount Paid | Open Rec | Terms | Expected Date | Days Overdue | Paid in Full
2022-04-07 00:00:00 | 429509 | ALLIED |  | HEARN INDUSTRIAL | HEARN INDUSTRIAL | T00272 | 14804.49 |  |  |  | COD
2022-04-28 00:00:00 | 429509 | ALLIED |  | HEARN INDUSTRIAL | HEARN INDUSTRIAL | T00268 | 14804.49 |  |  |  | COD
2022-05-11 00:00:00 | 172370 | U6418 |  | AURORA AUTO WORKS | AURORA AUTO WORKS | M09426 | 5830 |  |  |  | COD
2022-05-11 00:00:00 | 172370 | U6459 |  | AURORA AUTO WORKS | AURORA AUTO WORKS | M09426 | 0 |  |  |  | COD
2022-05-11 00:00:00 | 382580 | N7349 |  | FERROUS PROCESSING | SLS RECYCLING | H04433 | 66988 |  |  |  | COD
2022-05-11 00:00:00 | 382580 | A1954 |  | FERROUS PROCESSING | SLS RECYCLING | H04433 | 0 |  |  |  | COD
2022-05-12 00:00:00 | 5262 | U6413 |  | PACKAGING PRODUCTS | PACKAGING PRODUCTS | M09465 | 18495 |  |  |  | COD
2022-05-12 00:00:00 | 5262 | B2568 |  | PACKAGING PRODUCTS | PACKAGING PRODUCTS | M09465 | 0 |  |  |  | COD
2022-05-12 00:00:00 | 382580 | [NAME] |  | FERROUS PROCESSING | GENESEE RECYCLING | H04434 | 66988 |  |  |  | COD
2022-05-12 00:00:00 | 382580 | A1955 |  | FERROUS PROCESSING | GENESEE RECYCLING | H04434 | 0 |  |  |  | COD
2022-05-17 00:00:00 | 103840 | [NAME] |  | AAA WIRE & ROPE | AAA WIRE & ROPE | M09263 | 9123.42 |  |  |  | COD
2022-05-17 00:00:00 | 382580 | A1957 |  | FERROUS PROCESSING | FERROUS PROCESSING | H04571 | 23710 |  |  |  | COD
2022-05-17 00:00:00 | 162600 | [NAME] |  | [NAME] | [NAME] | U02238 | 29986 |  |  |  | COD
2022-05-17 00:00:00 | 392311 | B2516 |  | FRESH CHOICE MARKET PLACE | FRESH CHOICE MARKET PLACE | Z00403 | 3034.78 |  |  |  | COD
2022-05-19 00:00:00 | 130815 | U6526 |  | EUREKA FARM MARKET | EUREKA FARM MARKET | M09539 | 2120 |  |  |  | COD
2022-05-20 00:00:00 | 392780 | U6561 |  | FROM ME 2 YOU LLC | FROM ME 2 YOU LLC | M09546 | 106 |  |  |  | COD
2022-05-20 00:00:00 | 365885 | U6543 |  | PRAIRIE [NAME] DAIRY | PRAIRIE [NAME] DAIRY | [NAME] | 6095 |  |  |  | COD
2022-05-20 00:00:00 | 365885 | B1289 |  | PRAIRIE [NAME] DAIRY | PRAIRIE [NAME] DAIRY | [NAME] | 2120 |  |  |  | COD
2022-05-26 00:00:00 | 216890 | [NAME] |  | BOMBSHELL TRUCKING | BOMBSHELL TRUCKING | M09547 | 6884.7 |  |  |  | COD
2022-05-26 00:00:00 | 216890 | [NAME] |  | BOMBSHELL TRUCKING | BOMBSHELL TRUCKING | M09547 | 3180 |  |  |  | COD
2022-05-26 00:00:00 | 216890 | C1698 |  | BOMBSHELL TRUCKING | BOMBSHELL TRUCKING | M09547 | 530 |  |  |  | COD
2022-05-26 00:00:00 | 785880 | U6237 |  | SYNVENTIVE MOLDING SOLUTIONS | SYNVENTIVE MOLDING SOLUTIONS | M09534 | 26494.7 |  |  |  | COD
2022-05-27 00:00:00 | 782330 | U6464 |  | SUPERIOR MATERIALS | SUPERIOR MATERIALS | H04572 | 38495 |  |  |  | COD
2022-05-31 00:00:00 | 829655 | U6549 |  | WASHTENAW INTERMEDIATE SCHOOL | WASHTENAW INTERMEDIATE SCHOOL | M09558 | 11995 |  |  |  | COD
2022-05-31 00:00:00 | 6641 | U6421 |  | VALUE WORLD | VALUE VILLAGE INC | H04554 | 23850 |  |  |  | COD
2022-05-31 00:00:00 | 782330 | U6299 |  | SUPERIOR MATERIALS | SUPERIOR MATERIALS | H04560 | 42750 |  |  |  | COD
2022-05-31 00:00:00 | 382440 | U6398 |  | FERNCO | FERNCO | [NAME] | 11446.97 |  |  |  | COD
2022-05-31 00:00:00 | 382440 | B2391 |  | FERNCO | FERNCO | [NAME] | 2655.31 |  |  |  | COD