Duplication

Closed
9000966 Posts 1 Registration date Wednesday 30 October 2013 Status Member Last seen 31 October 2013 - 31 Oct 2013 à 00:10
 9000966 - 10 Nov 2013 à 03:09
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
31 Oct 2013 à 09:44
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
still am waiting for solution