Duplication
Closed
9000966
Posts
1
Registration date
Wednesday October 30, 2013
Status
Member
Last seen
October 31, 2013
-
Oct 31, 2013 at 12:10 AM
9000966 - Nov 10, 2013 at 03:09 AM
9000966 - Nov 10, 2013 at 03:09 AM
Hi,
I a have a column A i.e names . for ex. 1 Row shailendra, 2 Row sailendra, 3 Row shylendra. above (3) names are same but spelling change now i wont to find the duplication or percentage of data matching
Thanks for helping
I a have a column A i.e names . for ex. 1 Row shailendra, 2 Row sailendra, 3 Row shylendra. above (3) names are same but spelling change now i wont to find the duplication or percentage of data matching
Thanks for helping
1 response
WOW, what a scope for a free tech site.
So, how big is this dictionary of names?
YOU will need the following:
Lists of Names containing Primary Name-and Secondary Spelling.
Primary name is an Array- something like:
Dim Shailendra(2)
Shailendra(0)=Shailendra
Shailendra(1)=Sailendra
Shailendra(2)=Shylendra
Check the cell contents for each array.
Unless you want to make a more intensive "phonetic" finder, this would be the easiest to deploy and scale. There is alot of manually building the Arrays though.
Anyone else have any ideas for such a scope (premier software)?
//ark
-Contributor
So, how big is this dictionary of names?
YOU will need the following:
Lists of Names containing Primary Name-and Secondary Spelling.
Primary name is an Array- something like:
Dim Shailendra(2)
Shailendra(0)=Shailendra
Shailendra(1)=Sailendra
Shailendra(2)=Shylendra
Check the cell contents for each array.
Unless you want to make a more intensive "phonetic" finder, this would be the easiest to deploy and scale. There is alot of manually building the Arrays though.
Anyone else have any ideas for such a scope (premier software)?
//ark
-Contributor
Nov 10, 2013 at 03:09 AM