percent matching of string 1 against string 2 in excel
Posted on 2013-11-11
I have two columns in excel that I'm trying to figure out how closely the two columns match with each other.
Lets say I have a column of strings (column A), and another column (column B) that I want to match against. I want to take each cell in column A, and get a "percent match" in all the cells in B so I can find the closest match in column B.
Also, the stings would be something "Cell reconfiguration engineering AA145-78XR" against "Setup AA145-78XR" which should be a close match.