Duplication

[Closed]
Report
Posts
1
Registration date
Wednesday October 30, 2013
Status
Member
Last seen
October 31, 2013
-
 9000966 -
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 reply


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