Fuzzy match

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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!

3 replies


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.
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!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768