-
Wanted: Testing and feedback of Duplicate Master addin V2.0
Hi All,
I have made some significant upgrades to the Duplicate Master addin, mainly on string comparison where the tool now offers- case insensitive searches
- ignore all whitespace searches (ASCII 9-13,32,160)
- apply the worksheet CLEAN and/or TRIM functions,
and for those who want some serious matching capability- Regular Expression functionality (for example treat all numeric strings as "x", treat fred/frederick/freddy/fredy as fred etc)
The addin processing logic has also been optimised significantly and should be much quicker if running on all sheets on very large files
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>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules