Forum Discussion

marcwithak629's avatar
marcwithak629
Brass Contributor
Apr 03, 2024

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 "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

excel
Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 04, 2024

    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

Resources