Remove duplicates in Excel

You usually have to remove duplicates in Excel if you merge several databases and this leads to unwanted duplications. Since Microsoft Excel 2007, there is a very simple solution for deleting that detects and eliminates duplicates in your table.

Delete duplicates in Excel

To find and delete duplications, there is a helpful button in your Excel program:

1. First check whether all text content in your Excel spreadsheet has the same formatting. Because the same font, size and font style are the prerequisites for Excel to recognize duplicates.
2. Now mark the columns from which you want to filter out the duplicates and then click on the "Data" button in the menu bar.
3. Here you click the "Remove duplicates" button. A window will now open informing you that duplicates will be removed from the area you selected.
4. Click OK". Excel then tells you whether and how many duplicates have been found and removed, and how many unique values ​​still remain.

These instructions refer to Microsoft Excel 2010.