A
Alaughli
Alright I work in large database files and I need to move around alot of
information according to company name, we don't have account numbers.
Alot of times the list of companies i need info for has different names
then the company in the database.
e.g.
I need info for company XYZ Company, Inc
and in the databse it might be entered as X Y Z Comp, Incorporated
I was wondering if there was some vb macro that could take a name a
search for a best possible match like a query kind of and return the
top 10 matches or something
the logical progression of the program might go something like this:
1. Delete all periods, commas
2. Somethign that defines Inc, incorporated, as the same and comp, and
companyy as the same
3. then matches for the most ammount of similiar characters in the
order of the cel
4. matches characters of uncommon names first and then common parts of
the name like corp ltd llc inc second.
Maybee u have better Ideas basically in looking for a good search
engine in excel that will bring back the correct database name so I can
use vlookuk for thousands of companies to get the data i need. Granted
with # this would not be a problem.
I i need it at a character level in case there are missspellings, so if
i have XYZ Gigets
and the only company in the database is
XYZ gigdets i would like that to come up because it matches most of the
characters int he right order.
information according to company name, we don't have account numbers.
Alot of times the list of companies i need info for has different names
then the company in the database.
e.g.
I need info for company XYZ Company, Inc
and in the databse it might be entered as X Y Z Comp, Incorporated
I was wondering if there was some vb macro that could take a name a
search for a best possible match like a query kind of and return the
top 10 matches or something
the logical progression of the program might go something like this:
1. Delete all periods, commas
2. Somethign that defines Inc, incorporated, as the same and comp, and
companyy as the same
3. then matches for the most ammount of similiar characters in the
order of the cel
4. matches characters of uncommon names first and then common parts of
the name like corp ltd llc inc second.
Maybee u have better Ideas basically in looking for a good search
engine in excel that will bring back the correct database name so I can
use vlookuk for thousands of companies to get the data i need. Granted
with # this would not be a problem.
I i need it at a character level in case there are missspellings, so if
i have XYZ Gigets
and the only company in the database is
XYZ gigdets i would like that to come up because it matches most of the
characters int he right order.