1) I need a formula to identify partial word matches in Excel. Below are a few rows from my spreadsheet with three home sales shown. I need a formula to identify when the seller and buyer rows "match" because there are some matching names. In these examples, the "transactions" do NOT reflect the sale of a home, just the change in the legal ownership. I'm guessing this is probably easy for a lot of you and hope someone can quickly give me a solution. My goal is to search the database and add an * in two columns for all of the matches: one * next to the seller and one next to the buyer.
| 118 Oxford Drive |
| Date Jan. 5 |
| Price N/A |
| Seller2019 B Family Trust and Deborah O and James G Ber |
| Joe Deborah and Emily Deborah |
| 100 Hardie Drive |
| Date Jan. 5 |
| Price N/A |
| Seller Weber Family Trust and Michael L. Weber |
| Buyer Michael L. Weber |
| 1519 Camino Peral |
| Date Jan. 4 |
| Price N/A |
| Seller Asher and Rosenda R. M. Levy |
Buyer Levy Family Trust and Asher and Rosenda R. M. Levy |
