Forum Discussion
Partial Match in Excel between two cells with multiple words in each cell
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 "matc...
So what is your expected outcome for these combinations in your example:
Seller2019 B Family Trust and Deborah O and James G Ber
Joe Deborah and Emily Deborah
and
| Seller Weber Family Trust and Michael L. Weber |
| Buyer Michael L. Weber |
and
Seller Asher and Rosenda R. M. Levy
Buyer Levy Family Trust and Asher and Rosenda R. M. Levy