Share via

Fuzzy Match in Excel

Anonymous
2023-12-06T05:41:30+00:00

Hi, I am looking for a way to perform a fuzzy match in Excel comparing two different cells. eg below the circled cells do not have a perfect match , so is there a formula that could return a % match based on common words and numbers regardless of the order?

thanks

Chris

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2023-12-07T04:31:23+00:00

    You are welcome. You may also give feedback on it. Thank You:)

    1 person found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-06T06:35:26+00:00

    Try this one, it will match each word separated by blank and get a percentage. Feel free to share any rule you want to add to this formula.

    =LET(a,TEXTSPLIT(SUBSTITUTE(A2,",","")," "),SUM(--ISNUMBER(SEARCH(a,B2)))/COUNTA(a))

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-12-07T04:25:09+00:00

    Thank you Snow! This works as expected and a great solution

    0 comments
  3. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2023-12-06T23:44:28+00:00

    Hi,

    In cell C2, enter this formula

    =MAP(A2:A9,B2:B9,LAMBDA(x,y,LET(a,TEXTSPLIT(y,," "),TEXTJOIN(", ",1,SORT(XLOOKUP(TEXTSPLIT(x,," "),a,a,""))))))

    Hope this helps.

    0 comments