Comparing two Strings and display percentage match

Question

I work as a project planner. And I receive submittals for project ideas regularly. And some of these ideas have been rejected previously.

However, customers sometimes re-submit these ideas repeatedly, sometimes with the exact description and sometimes with slight changes to the project description.

I am trying to develop a way to filter out and catch re-submitted project ideas and similar ones by comparing them to an exacting date base by doing stings comparison to find the similarities and show the percentage %.

For example:

• 1- “Build me a new bridge” vs. “Build me a new bridge” would return 100%
• 2-“Build me a new bridge “ vs. “ Build me a bridge “ would return 80%

Is there a way to implement these functionalities on MS Excel or UiPath StudioX?

Answer 1

So, this may be what you mean, but you might need to expand it:

=(COUNT(IFERROR(FIND(TEXTSPLIT(SUBSTITUTE(B2," ",","),",",,1,,),A2,),0))/COUNTA(IFERROR(TEXTSPLIT(SUBSTITUTE(A2," ",","),",",,1,,),0)))*100

Updated with your last two examples and it works:

---