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
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

1 response

Blocked Profile
Oct 31, 2013 at 09:44 AM
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
0
still am waiting for solution
0