I need an Excel Macro that can compare names within a column: I have a large Excel worksheet with a very long list of Companies' names (about 30,000) on the column A of the worksheet. I need a Macro that can compare the name of, for e.g., row 2 with row 3 and see if they are at least 90% match*. If they do, then the Macro can copy the name in row 2 onto row 3 (i.e. overwriting row 3). Then the Macro will go to the next row comparing row 3 with row 4...and so on until it reaches the end of the list. *I am open for suggestion as to how to define 90% match.
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
Excel 97 and 2000 for Windows NT and 2000