Forum Discussion
fuzzy match on a column
I have 2 columns of data, see test file below. Column A has names of colleges provided by a vendor. Column B has names of colleges from my database. In A many are the same college. I have 700 names i...
For the previous versions of Excel it was Fuzzy-Match add-in, but doesn't supported any more. For recent version fuzzy match is built into the Power Query, but it's not very reliable. You may check attached.
SergeiBaklanthank you for pointing me in the right direction. I will learn how to use Power Query!