Spreadsheet: 840324d1692645780-search-for-matching-names-in-workbook-then-compile-different-cells-into-logical-order-example-workbook
Sheet: Sheet1

 |  | 2022-10-10 00:00:00 |  |  |  |  |  |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net
Oak Ridge-TX | 1 | x | 1 | x | 1 | x |  |  | Palm Coast-FL | 1 | x | 1 | x | 1 | x |  | Arrowhead Reserve-FL | 1 | x | 1 | x | 1 | x |  | Homeplace at Riverside/Brookfield-WV | 1 | x | 1 | x | 1 | x
Preserve at Medina-TX | 2 | x | 2 | x | 2 | x |  |  | Big Sky Estates-TX | 2 | x | 2 | x | 2 | x |  | Connell Park-WA | 2 | x | 2 | x | 2 | x |  | Preserve at Medina-TX | 2 | x | 2 | x | 2 | x
Logan Square/Lasater Ranch-TX | 1 | x | 1 | x | 1 | x |  |  | [NAME] | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x
[NAME] | 2 | x | 2 | x | 2 | x |  |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Stone Crest Estate-GA | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x
[NAME] | 1 | x | 1 | x | 1 | x |  |  | The Meadows-NC | 1 | x | 1 | x | 1 | x |  | Preserve at Medina-TX | 1 | x | 1 | x | 1 | x |  | North Port-FL | 1 | x | 1 | x | 1 | x
[NAME] | 2 | x | 2 | x | 2 | x |  |  | Oak Ridge-TX | 2 | x | 2 | x | 2 | x |  | Big Sky Estates-TX | 2 | x | 2 | x | 2 | x |  | The Meadows-NC | 2 | x | 2 | x | 2 | x
Palm Coast-FL | 1 | x | 1 | x | 1 | x |  |  | Morningside Trails-TX | 1 | x | 1 | x | 1 | x |  | [NAME]Cypress Pointe-CA | 1 | x | 1 | x | 1 | x |  | Hamlets of Tavares-FL | 1 | x | 1 | x | 1 | x
South Park Meadows/Princeton Crossroads-TX | 2 | x | 2 | x | 2 | x |  |  | Pierson Park-CO | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Carlisle Village/Miske Meadows/Maefield Estates-MN | 2 | x | 2 | x | 2 | x
White Tail Ridge/Willow Creek/Riverpointe/Lake Ridge-MN | 1 | x | 1 | x | 1 | x |  |  | Mirror Lakes-FL | 1 | x | 1 | x | 1 | x |  | Colonial Crossing-NC | 1 | x | 1 | x | 1 | x |  | [NAME]'s Point-AL | 1 | x | 1 | x | 1 | x
Shaw Creek Ranch-TX | 2 | x | 2 | x | 2 | x |  |  | Shaw Creek Ranch-TX | 2 | x | 2 | x | 2 | x |  | Poinciana-FL | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x
Hidden Creek North-CO | 1 | x | 1 | x | 1 | x |  |  | Mirada-FL | 1 | x | 1 | x | 1 | x |  | Logan Square/Lasater Ranch-TX | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x
[NAME] | 2 | x | 2 | x | 2 | x |  |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Homestead Estates-TX | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x
Luckey Ranch-TX | 1 | x | 1 | x | 1 | x |  |  | The Orchards/Port Towne at Bridgeway Lakes-CA | 1 | x | 1 | x | 1 | x |  | Morningside Trails-TX | 1 | x | 1 | x | 1 | x |  | Deltona Deland-FL | 1 | x | 1 | x | 1 | x
[NAME] | 2 | x | 2 | x | 2 | x |  |  | Preserve at Medina-TX | 2 | x | 2 | x | 2 | x |  | Port St. Lucie-FL | 2 | x | 2 | x | 2 | x |  | Mirror Lakes-FL | 2 | x | 2 | x | 2 | x
[NAME] | 1 | x | 1 | x | 1 | x |  |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Reunion Village-FL | 1 | x | 1 | x | 1 | x |  | Sunrise Estates-AZ | 1 | x | 1 | x | 1 | x
 |  | 2022-11-07 00:00:00 |  |  |  |  |  |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net
Terravista-AZ | 1 | x | 1 | x | 1 | x |  |  | Terravista-AZ | 1 | x | 1 | x | 1 | x |  | Terravista-AZ | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x
Cannery Park-CA | 2 | x | 2 | x | 2 | x |  |  | North Port-FL | 2 | x | 2 | x | 2 | x |  | Cannery Park-CA | 2 | x | 2 | x | 2 | x |  | Second Creek Farm-CO | 2 | x | 2 | x | 2 | x
Sunrise Estates-AZ | 1 | x | 1 | x | 1 | x |  |  | Summit at Liberty-CA | 1 | x | 1 | x | 1 | x |  | Logan Square/Lasater Ranch-TX | 1 | x | 1 | x | 1 | x |  | Mirror Lakes-FL | 1 | x | 1 | x | 1 | x
Big Sky Estates-TX | 2 | x | 2 | x | 2 | x |  |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Homestead Estates-TX | 2 | x | 2 | x | 2 | x |  | Cannery Park-CA | 2 | x | 2 | x | 2 | x
Mirada-FL | 1 | x | 1 | x | 1 | x |  |  | Arrowhead Reserve-FL | 1 | x | 1 | x | 1 | x |  | Atherstone-NC | 1 | x | 1 | x | 1 | x |  | Parker's Gate-NC | 1 | x | 1 | x | 1 | x
[NAME] | 2 | x | 2 | x | 2 | x |  |  | Sunrise Estates-AZ | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Atherstone-NC | 2 | x | 2 | x | 2 | x
[NAME] | 1 | x | 1 | x | 1 | x |  |  | [NAME] | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Estrella-AZ | 1 | x | 1 | x | 1 | x
[NAME] | 2 | x | 2 | x | 2 | x |  |  | Shadowbend-TX | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Oak Ridge-TX | 2 | x | 2 | x | 2 | x
Pierson Park-CO | 1 | x | 1 | x | 1 | x |  |  | Oak Ridge-TX | 1 | x | 1 | x | 1 | x |  | Poinciana-FL | 1 | x | 1 | x | 1 | x |  | Cape Coral North-FL | 1 | x | 1 | x | 1 | x
Oak Ridge-TX | 2 | x | 2 | x | 2 | x |  |  | Luckey Ranch-TX | 2 | x | 2 | x | 2 | x |  | Mirada-FL | 2 | x | 2 | x | 2 | x |  | Meadows Farm-GA | 2 | x | 2 | x | 2 | x
Port St. Lucie-FL | 1 | x | 1 | x | 1 | x |  |  | Poinciana-FL | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Cape Coral South-FL | 1 | x | 1 | x | 1 | x
[NAME] | 2 | x | 2 | x | 2 | x |  |  | Riverstone-FL | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Summit at Liberty-CA | 2 | x | 2 | x | 2 | x
[NAME] | 1 | x | 1 | x | 1 | x |  |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Autumn Lakes-NC | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x
Shadowbend-TX | 2 | x | 2 | x | 2 | x |  |  | Pecos Crossings-NV | 2 | x | 2 | x | 2 | x |  | Miske Meadows/Maefield Estates-MN | 2 | x | 2 | x | 2 | x |  | The Orchards-CA | 2 | x | 2 | x | 2 | x
Bridgewood Coves-GA | 1 | x | 1 | x | 1 | x |  |  | Homestead Estates-TX | 1 | x | 1 | x | 1 | x |  | Preserve at Medina-TX | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x
 |  | 2022-12-05 00:00:00 |  |  |  |  |  |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net |  |  |  | Sold |  | Canceled |  | Net
Knights Bridge-SC | 1 | x | 1 | x | 1 | x |  |  | Port St. Lucie-FL | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Sunrise Estates-AZ | 1 | x | 1 | x | 1 | x
[NAME] | 2 | x | 2 | x | 2 | x |  |  | Mirada-FL | 2 | x | 2 | x | 2 | x |  | Vacek Country Meadows-TX | 2 | x | 2 | x | 2 | x |  | Cape Coral North-FL | 2 | x | 2 | x | 2 | x
Cannery Park-CA | 1 | x | 1 | x | 1 | x |  |  | Logan Square/Lasater Ranch-TX | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Arrowhead Reserve-FL | 1 | x | 1 | x | 1 | x
Homeplace at Riverside/Brookfield-WV | 2 | x | 2 | x | 2 | x |  |  | Terravista-AZ | 2 | x | 2 | x | 2 | x |  | Prairie Creek Farms-WA | 2 | x | 2 | x | 2 | x |  | Pecos Crossings-NV | 2 | x | 2 | x | 2 | x
Summit at Liberty-CA | 1 | x | 1 | x | 1 | x |  |  | Mirror Lakes-FL | 1 | x | 1 | x | 1 | x |  | The Tate Reserve-GA | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x
Big Sky Estates-TX | 2 | x | 2 | x | 2 | x |  |  | Atherstone-NC | 2 | x | 2 | x | 2 | x |  | Poinciana-FL | 2 | x | 2 | x | 2 | x |  | Shaw Creek Ranch-TX | 2 | x | 2 | x | 2 | x
Homestead Estates-TX | 1 | x | 1 | x | 1 | x |  |  | Hamlets of Tavares-FL | 1 | x | 1 | x | 1 | x |  | Connell Park-WA | 1 | x | 1 | x | 1 | x |  | Luckey Ranch-TX | 1 | x | 1 | x | 1 | x
[NAME] | 2 | x | 2 | x | 2 | x |  |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Summit at Liberty-CA | 2 | x | 2 | x | 2 | x |  | Summit at Liberty-CA | 2 | x | 2 | x | 2 | x
[NAME] | 1 | x | 1 | x | 1 | x |  |  | Knights Bridge-SC | 1 | x | 1 | x | 1 | x |  | [NAME]Cypress Pointe-CA | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x
Vacek Country Meadows-TX | 2 | x | 2 | x | 2 | x |  |  | Meadows Farm-GA | 2 | x | 2 | x | 2 | x |  | The Meadows-NC | 2 | x | 2 | x | 2 | x |  | The Orchards-CA | 2 | x | 2 | x | 2 | x
Reunion Village-FL | 1 | x | 1 | x | 1 | x |  |  | Morningstar Ranch-CA | 1 | x | 1 | x | 1 | x |  | Sunset Village-OR | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x
Luckey Ranch-TX | 2 | x | 2 | x | 2 | x |  |  | Poinciana-FL | 2 | x | 2 | x | 2 | x |  | Pecos Crossings-NV | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x
[NAME]'s Point-AL | 1 | x | 1 | x | 1 | x |  |  | [NAME]'s Point-AL | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | Hamlets of Tavares-FL | 1 | x | 1 | x | 1 | x
SC Ranch-AZ | 2 | x | 2 | x | 2 | x |  |  | [NAME] | 2 | x | 2 | x | 2 | x |  | [NAME] | 2 | x | 2 | x | 2 | x |  | Morningstar Ranch-CA | 2 | x | 2 | x | 2 | x
North Port-FL | 1 | x | 1 | x | 1 | x |  |  | Reunion Village-FL | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x |  | [NAME] | 1 | x | 1 | x | 1 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0