With this handy add-in you can easily find and remove duplicates or unique records from Microsoft Excel lists or tables. Search for duplicates in one range or compare two lists with different number of columns, choose columns for comparison. You can delete duplicates from any range, select, color, copy or move them to another location (new workbook, new/existing worksheet). It works with Microsoft Excel 2007, 2003, 2002, 2000.
Latest changes:
- ADDED: Adding a number to the column name in case two or more columns have the same names.
- ADDED: Improved processing of Query Table.