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>