Ablebits.com Duplicate Remover for Excel

With this handy add-in you can quickly find and remove duplicates or unique records from Excel sheets. Search for duplicates in one table or compare two lists with different number of columns, choose any columns for comparison. Delete duplicate rows from any range, select, color them or add a status column, copy or move them to another location (worksheet or workbook). Duplicate Remover can easily handle up to 1 million rows in Excel 2013, 2010 -