Spreadsheet: 840485d1692777936-search-for-matching-names-in-workbook-then-compile-different-cells-into-logical-order-example-workbook
Sheet: Sheet2

 | 2023-01-02 00:00:00 |  |  |  |  |  |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net
Big Sky Estates-TX | 1 | x | 1 | x | 1 | x |  | Oak Ridge-TX | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Cannery Park-CA | 16 | x | 3 | x | 13 | x
Port St. Lucie-FL | 2 | x | 2 | x | 2 | x |  | Mirror Lakes-FL | 2 | x | 2 | x | 2 | x |  | Riverwalk-NC | 2 | x | 2 | x | 2 | x |  | Riverwalk-NC | 12 | x | 0 | x | 12 | x
[NAME] | 1 | x | 1 | x | 1 | x |  | Knights Bridge-SC | 1 | x | 1 | x | 1 | x |  | Preserve at Medina-TX | 1 | x | 1 | x | 1 | x |  | Oak Ridge-TX | 10 | x | 2 | x | 8 | x
Oak Ridge-TX | 2 | x | 2 | x | 2 | x |  | Luckey Ranch-TX | 2 | x | 2 | x | 2 | x |  | Port St. Lucie-FL | 2 | x | 2 | x | 2 | x |  | [NAME] | 12 | x | 5 | x | 7 | x
[NAME] | 1 | x | 1 | x | 1 | x |  | Big Sky Estates-TX | 1 | x | 1 | x | 1 | x |  | Shadowbend-TX | 1 | x | 1 | x | 1 | x |  | Knights Bridge-SC | 7 | x | 1 | x | 6 | x
Summit at Liberty-CA | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Pecos Crossings-NV | 2 | x | 2 | x | 2 | x |  | [NAME] | 7 | x | 1 | x | 6 | x
[NAME] | 1 | x | 1 | x | 1 | x |  | Logan Square/Lasater Ranch-TX | 1 | x | 1 | x | 1 | x |  | 5th Plain Creek Station-OR | 1 | x | 1 | x | 1 | x |  | [NAME] | 8 | x | 3 | x | 5 | x
Mirada-FL | 2 | x | 2 | x | 2 | x |  | The Orchards-CA | 2 | x | 2 | x | 2 | x |  | Second Creek Farm-CO | 2 | x | 2 | x | 2 | x |  | Prairie Creek Farms-WA | 6 | x | 1 | x | 5 | x
Palm Coast-FL | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Luckey Ranch-TX | 1 | x | 1 | x | 1 | x |  | [NAME] | 6 | x | 1 | x | 5 | x
Meadows Farm-GA | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | The Orchards-CA | 2 | x | 2 | x | 2 | x |  | Logan Square/Lasater Ranch-TX | 6 | x | 1 | x | 5 | x
Deltona Deland-FL | 1 | x | 1 | x | 1 | x |  | Prairie Creek Farms-WA | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Connell Park-WA | 6 | x | 1 | x | 5 | x
[NAME] | 2 | x | 2 | x | 2 | x |  | Hamlets of Tavares-FL | 2 | x | 2 | x | 2 | x |  | Vistas at Huning Ranch-NM | 2 | x | 2 | x | 2 | x |  | Big Sky Estates-TX | 6 | x | 1 | x | 5 | x
Mirror Lakes-FL | 1 | x | 1 | x | 1 | x |  | Vacek Country Meadows-TX | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Sunrise Estates-AZ | 5 | x | 0 | x | 5 | x
[NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | New South Bridge-NC | 5 | x | 0 | x | 5 | x
Hidden Creek North-CO | 1 | x | 1 | x | 1 | x |  | Hidden Creek North-CO | 1 | x | 1 | x | 1 | x |  | Mission Ranch-AZ | 1 | x | 1 | x | 1 | x |  | [NAME] | 9 | x | 5 | x | 4 | x
 | 2023-01-30 00:00:00 |  |  |  |  |  |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net
Parker's Gate-NC | 1 | x | 1 | x | 1 | x |  | Summit at Liberty-CA | 1 | x | 1 | x | 1 | x |  | Royal Highlands-FL | 1 | x | 1 | x | 1 | x |  | Riverwalk-NC | 11 | x | 2 | x | 9 | x
[NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Shadowbend-TX | 9 | x | 2 | x | 7 | x
Port St. Lucie-FL | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Cannery Park-CA | 7 | x | 0 | x | 7 | x
Knights Bridge-SC | 2 | x | 2 | x | 2 | x |  | The Orchards-CA | 2 | x | 2 | x | 2 | x |  | Preserve at Medina-TX | 2 | x | 2 | x | 2 | x |  | New South Bridge-NC | 7 | x | 0 | x | 7 | x
The Orchards-CA | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Ridgeview Estates/Estrella-AZ | 7 | x | 0 | x | 7 | x
Terravista-AZ | 2 | x | 2 | x | 2 | x |  | 5th Plain Creek Station-OR | 2 | x | 2 | x | 2 | x |  | Knights Bridge-SC | 2 | x | 2 | x | 2 | x |  | Tenny Creek-OR | 8 | x | 2 | x | 6 | x
Shaw Creek Ranch-TX | 1 | x | 1 | x | 1 | x |  | Homeplace at Riverside/Brookfield-WV | 1 | x | 1 | x | 1 | x |  | Homestead Estates-TX | 1 | x | 1 | x | 1 | x |  | [NAME] | 7 | x | 1 | x | 6 | x
5th Plain Creek Station-OR | 2 | x | 2 | x | 2 | x |  | South Park Meadows-TX | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Terravista-AZ | 6 | x | 0 | x | 6 | x
[NAME] | 1 | x | 1 | x | 1 | x |  | Terravista-AZ | 1 | x | 1 | x | 1 | x |  | [NAME]'s Retreat-TN | 1 | x | 1 | x | 1 | x |  | Mirror Lakes-FL | 13 | x | 8 | x | 5 | x
Reunion Village-FL | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Pierson Park-CO | 2 | x | 2 | x | 2 | x |  | Sunset Village-OR | 6 | x | 1 | x | 5 | x
Vistas at Huning Ranch-NM | 1 | x | 1 | x | 1 | x |  | Palm Coast-FL | 1 | x | 1 | x | 1 | x |  | Mirror Lakes-FL | 1 | x | 1 | x | 1 | x |  | Knights Bridge-SC | 6 | x | 1 | x | 5 | x
[NAME] | 2 | x | 2 | x | 2 | x |  | Riverwalk-NC | 2 | x | 2 | x | 2 | x |  | Hamlets of Tavares-FL | 2 | x | 2 | x | 2 | x |  | Pierson Park-CO | 7 | x | 3 | x | 4 | x
Cottonwood Greens/Evans Place-CO | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | North Port-FL | 1 | x | 1 | x | 1 | x |  | 5th Plain Creek Station-OR | 7 | x | 3 | x | 4 | x
Cannery Park-CA | 2 | x | 2 | x | 2 | x |  | Luckey Ranch-TX | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 6 | x | 2 | x | 4 | x
Hamlets of Tavares-FL | 1 | x | 1 | x | 1 | x |  | Meadows Farm-GA | 1 | x | 1 | x | 1 | x |  | Brookwood-VA | 1 | x | 1 | x | 1 | x |  | Meadows Farm-GA | 6 | x | 2 | x | 4 | x
 | 2023-02-27 00:00:00 |  |  |  |  |  |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net
[NAME] | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | McKee Creek Village-NC | 1 | x | 1 | x | 1 | x |  | [NAME] | 12 | x | 0 | x | 12 | x
Riverchase Estates-SC | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | LaLonde Creek/Tenny Creek-OR | 2 | x | 2 | x | 2 | x |  | Satterfield Farm-NC | 11 | x | 0 | x | 11 | x
Shadowbend-TX | 1 | x | 1 | x | 1 | x |  | Royal Highlands-FL | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | McKee Creek Village-NC | 15 | x | 5 | x | 10 | x
Big Sky Estates-TX | 2 | x | 2 | x | 2 | x |  | Vistas at Huning Ranch-NM | 2 | x | 2 | x | 2 | x |  | Hightop Ridge-TX | 2 | x | 2 | x | 2 | x |  | Pierson Park-CO | 14 | x | 4 | x | 10 | x
Prairie Creek Farms-WA | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Preserve at Medina-TX | 1 | x | 1 | x | 1 | x |  | Logan Square/Lasater Ranch-TX | 13 | x | 3 | x | 10 | x
The Orchards-CA | 2 | x | 2 | x | 2 | x |  | Riverwalk-NC | 2 | x | 2 | x | 2 | x |  | Hidden Creek North/Sorrento-CO | 2 | x | 2 | x | 2 | x |  | Big Sky Estates-TX | 10 | x | 0 | x | 10 | x
Hamlets of Tavares-FL | 1 | x | 1 | x | 1 | x |  | Cape Coral-FL | 1 | x | 1 | x | 1 | x |  | Riverwalk-NC | 1 | x | 1 | x | 1 | x |  | The Orchards-CA | 11 | x | 2 | x | 9 | x
Country Walk/Mission Ranch/Sunrise Estates-AZ | 2 | x | 2 | x | 2 | x |  | Colonial Crossing-NC | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 11 | x | 3 | x | 8 | x
Shaw Creek Ranch-TX | 1 | x | 1 | x | 1 | x |  | [NAME]'s Retreat-TN | 1 | x | 1 | x | 1 | x |  | Vistas at Huning Ranch-NM | 1 | x | 1 | x | 1 | x |  | [NAME] | 10 | x | 3 | x | 7 | x
[NAME] | 2 | x | 2 | x | 2 | x |  | Miske Meadows/Maefield Estates-MN | 2 | x | 2 | x | 2 | x |  | Ridgeview Estates/Estrella-AZ | 2 | x | 2 | x | 2 | x |  | [NAME] | 7 | x | 0 | x | 7 | x
Morningside Trails-TX | 1 | x | 1 | x | 1 | x |  | Shadowbend-TX | 1 | x | 1 | x | 1 | x |  | Morningside Trails-TX | 1 | x | 1 | x | 1 | x |  | White Tail Ridge/Riverpointe/Lake Ridge-MN | 7 | x | 0 | x | 7 | x
New South Bridge-NC | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Luckey Ranch-TX | 10 | x | 4 | x | 6 | x
Riverstone-FL | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Luckey Ranch-TX | 1 | x | 1 | x | 1 | x |  | [NAME] | 10 | x | 4 | x | 6 | x
[NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 10 | x | 4 | x | 6 | x
Esperanza-TX | 1 | x | 1 | x | 1 | x |  | Atherstone-NC | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | [NAME] | 8 | x | 3 | x | 5 | x