Duplicate Finder & Deleter Improvements
The latest release of the Duplicate Finder & Deleter is 7.0. It is Excel 2007-2019 and Office 365 compatible.
- Added code to detect some corruption issues in workbooks improperly created by web sites. Such workbooks have incorrect cell formatting that prevents formulas from being written.
- Fixed a problem with Excel incorrectly selected cells in very rare situations. Most likely caused by a Excel 365 update
- Fixed a Windows 10 bug that caused dialogs to appear incorrectly and difficult to read or use.
- Product review and improvements
- Fixed an Excel bug with dialogs not
always appearing in the center of the Excel window if the user has two
or more monitors.
- Minor change to the find duplicates in a block of cells feature
- Fixed a problem with comparing two lists and extremely few matches occurring
- Speed improvements and minor menu improvements
- Modified so that when asked for the top row of the data
range, the user only has to type in the row number as a number (vs for
example, 2:2, or having to scroll and select the row)
- Added a check of the data on a worksheet to see if has been
converted to an Excel data list, and if so, advise the user to convert
back to a normal Excel range before using the add-in. A bug in
Excel requires this. As few users use Excel data lists, few are
- Minor installation improvements
- Modified so that ascii character 160, which looks like a
space, is treated as a keyboard space, which is ascii character
32. Ascii character 160 is normally only used in HTML pages as a
non-breaking space to align text. It should not part of computer
generated data or downloaded data. One of our customers had data
that had ascii 160 in one list and regular spaces in another list,
resulting in no duplicates being found as the characters were
- Minor title and wording changes
- Modified to insure that user does not accidentally pick hidden columns when selecting comparison columns.
- Added in a top data row confirmation if the first data
row is below row 5. This was done to help insure that the user
correctly picks the first row of data and doesn't accidentally pick a
starting row below the top of the data.