Fuzzy match Closed

Question

Hello, 

I have two columns, both contain hospital names but they are not exactly the same.  I want to determine if hospitals in column A are in column B.  I think I should be using the match function.  Any suggestions?

Thanks!

Configuration: Mac OS X / Firefox 3.6.10

brianwhitt77 · Answer

Dear Ryko, 

Please get the problem solved through  the following help.

https://ccm.net/faq/6874-excel-compare-two-columns-and-delete-duplicates

https://ccm.net/faq/6461-excel-comparing-two-columns-a-b

Thank you.

Ryko · Answer

I do not think these will work.  It cannot be an exact match, and the columns contain only names of hospitals that actually are the same, but in the columns they are slightly different.  Ex: Rush University Medical Center vs. Rush Medical Center.  I want to find out the hospitals in column A, that are also in column B..  Does this make sense?  

Thanks!

rizvisa1 · Answer

See this Ryko

https://www.mrexcel.com/board/threads/fuzzy-matching-new-version-plus-explanation.195635/#post-955137

Fuzzy match

3 responses

Similar discussions

Subscribe To Our Newsletter!