home page
Questions? E-mail us or call us 302-584-1771, 8AM to 10PM U.S. East Coast Time 7 days a week


Money back

Duplicate Finder & Deleter Improvements

The latest release of the Duplicate Finder & Deleter is 7.0.  It is Excel 2007-2021 and Office 365 compatible. 

Latest improvements:

  • 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 impacted.
  • 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 different.
  • 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.

Copyright 2022 LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of LLC.