I have a long list of company names and I want to eliminate approximate matches.
For example, my list includes the following:
CENTAURUS ENERGY MASTER FUND L.P.
Centaurus Financial
Centaurus Financial Inc.
Centech Group
In this case, I would want to identify "Centaurus Financial" and "Centaurus Financial Inc." as the same but the others should be considered different. I realize that I will have to review the list manually afterwards.
I have the Fuzzy Lookup add-on from Microsoft but since I am comparing a list to itself, every item on the list produces a 100% match and then any approximate match gets matched up with the other one. For example, "Centaurus Financial" gets fuzzy-matched with "Centaurus Financial Inc." and vice-versa, whereas I want to be able to say both companies are close but not exact.
I have always appreciated this forum's help. Thank you!
For example, my list includes the following:
CENTAURUS ENERGY MASTER FUND L.P.
Centaurus Financial
Centaurus Financial Inc.
Centech Group
In this case, I would want to identify "Centaurus Financial" and "Centaurus Financial Inc." as the same but the others should be considered different. I realize that I will have to review the list manually afterwards.
I have the Fuzzy Lookup add-on from Microsoft but since I am comparing a list to itself, every item on the list produces a 100% match and then any approximate match gets matched up with the other one. For example, "Centaurus Financial" gets fuzzy-matched with "Centaurus Financial Inc." and vice-versa, whereas I want to be able to say both companies are close but not exact.
I have always appreciated this forum's help. Thank you!