seriousdamage
Board Regular
- Joined
- Aug 14, 2005
- Messages
- 58
Hi All,
I have an excel file with about 30.000 company names, which I have sorted in alphabetical order. My goal is to find a relationship between this accounts only by looking at the name and see if they NEARLY match, so that I can consider them as 1 company and reduce the list.
Is there a formula that I can run to help me out?
I give you an example of what I would consider the same company.
UNION SDA FINANCE,
UNION DES SUCRERIES ET DISTILLERIES SDA FINANCE AGRICOLES,
RECTORAT DES SDA FINANCE SUCRERIES ET DISTILLERIES.
As you can see in all 3 records there is the word SDA FINANCE always present, which brings me to think that they could all be connected.
If then they are not that will be a different issue
Any help?
Thanks
NIC.
I have an excel file with about 30.000 company names, which I have sorted in alphabetical order. My goal is to find a relationship between this accounts only by looking at the name and see if they NEARLY match, so that I can consider them as 1 company and reduce the list.
Is there a formula that I can run to help me out?
I give you an example of what I would consider the same company.
UNION SDA FINANCE,
UNION DES SUCRERIES ET DISTILLERIES SDA FINANCE AGRICOLES,
RECTORAT DES SDA FINANCE SUCRERIES ET DISTILLERIES.
As you can see in all 3 records there is the word SDA FINANCE always present, which brings me to think that they could all be connected.
If then they are not that will be a different issue
Any help?
Thanks
NIC.