Fuzzy match

Closed
ryko - Sep 16, 2010 at 09:58 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 17, 2010 at 10:08 AM
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 responses

Blocked Profile
Sep 17, 2010 at 07:28 AM
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.
0
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!
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 17, 2010 at 10:08 AM
0