Hello Guys,
I have 2 datssets i wnat to mtach the new dataset with the old one and gives %of match like shown below
Company master file like this :
Company_Master
Adamas Pharmaceuticals, Inc.
Acacia Communications, Inc.
McHugh Inc
I will recive new compay names frequently like this
Company_New
Adamas Pharmaceuticals, Inc.
Adimas Pharmaceuticals, Inc.
McHugh Inc
Mc Hugh innc
Mccley INC
Acacia Communications
I want output like below: match with the master file and gives the % match with the master file names..any ideas i am looking at some compare functions but that not giving satisfactory results. any thoughts?
Company_New
% Matched
Adamas Pharmaceuticals LLC
90
Adimas Pharmaceuticals
80
Adamas Pharmaceuticals, Inc.
100
McHugh Inc
100
Mc Hugh innc
90
Mccley INC
0
Acacia Communications
0
Thanks.
... View more