Hi All,
I have made some significant upgrades to the Duplicate Master addin, mainly on string comparison where the tool now offersand for those who want some serious matching capability
- case insensitive searches
- ignore all whitespace searches (ASCII 9-13,32,160)
- apply the worksheet CLEAN and/or TRIM functions,
The addin processing logic has also been optimised significantly and should be much quicker if running on all sheets on very large files
- Regular Expression functionality (for example treat all numeric strings as "x", treat fred/frederick/freddy/fredy as fred etc)
Lastly I have added an option to exclude any items from a unique list if they occur more than once
I would greatly appreciate any testing and feedback so that I can finalise this beta version. I am also open to including additional functionality
Attached in the addin in xls format. For those running XL2003 it will add a new menu item to the Tools commandbar
Much appreciated
Dave
<prior version of file removed. see bottom of thread>