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
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!
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!
Related:
- Fuzzy match
- Music match jukebox - Download - Audio playback
- Position of mouse pointer does not match screen coordinates clicked - Guide
- Royal match game download for pc - Download - Puzzle
- Partial match excel - Guide
- B. apply the subtle effect smartart style in the best match for document section. - Guide
3 responses
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.
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!
Thanks!
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 17, 2010 at 10:08 AM
Sep 17, 2010 at 10:08 AM