Nov 20 2022 03:13 AM
Could someone please assist with how I could compare two text strings to return a similarity score or a percentage in excel? Let's say cell A1 contains the text string “Computer” whereas cell B1 contains “Computer accessory”. I want a function that will return a percentage of say 75% in cell C1 when the two strings are compared. Thank you for the assistance!!!
Nov 20 2022 04:50 AM
See for example reply #7 in this discussion
Nov 20 2022 05:06 AM
@Hans Vogelaar Great!!! Thank you so much for the prompt feedback. I will check it out.