Question

Excel: remove duplicates - get rid of duplicate values

Answer 1

Find duplicate entries in Excel
1st step:
2nd step:
3rd step:
Remove duplicates from Excel
1st step:
2nd step:
3rd step:
Quick guide: Find duplicate entries in Excel
Quick guide: remove duplicates from Excel

---

Would you like to remove cells with duplicate entries directly from your Excel spreadsheet? We'll show you how..

Excel can be used as a data management program in a variety of ways. Sometimes it is necessary to remove all duplicate values ​​from the table. Here we show you how you can delete the duplicate values ​​from your table directly. We are also discussing the possibility of using a filter to search for the duplicate entries. So you can decide for each cell individually whether you want to delete it.

• Find duplicate entries in Excel
• Remove duplicates from Excel

Find duplicate entries in Excel

Follow our step-by-step instructions or take a look at the brief instructions .

1st step:

First, select all cells in which you want to search for duplicate values. Then click the top of the Home tab on " Conditional Formatting " and then select " Rules for highlighting cells ". In the following drop-down menu you now have to click on " Duplicate values ​​... ". A new window is opening up.

2nd step:

In the new window, use the drop-down menu to specify the color of the cells. Confirm your entry by clicking " OK ".

3rd step:

You can now see that all duplicate values are highlighted in color .

Remove duplicates from Excel

Follow our step-by-step instructions or take a look at the brief instructions ..

1st step:

First, select all cells from which you want to remove the duplicate entries. Then select the " Remove duplicates " option in the " Data " tab . It is located in the " Data Tools " area.

2nd step:

Now you have to choose from which columns of the highlighted area you want to remove duplicates. This window may seem a bit nonsensical for a single column, but this tool can prove to be very useful, especially for tables with a large number of named columns. Set or remove the check mark and then click on " OK ".

3rd step:

Finally, after the successful deletion, you will be shown how many duplicate values ​​have been removed and many unique values ​​still exist. You can close the pop-up with a click on " OK ". By the way: The cells with duplicates are normally deleted automatically. So you don't have to remove extra blank lines in Excel .

Quick guide: Find duplicate entries in Excel

1. Select all the cells that you want to check for duplicates.
2. In the " Start " tab, click on " Conditional Formatting ". Select " Rules for highlighting cells " and then " Duplicate values ​​... ".
3. In the new window you can now set the color in which duplicate values ​​are to be highlighted. With a click on " OK " all duplicate entries are marked in color with the help of the set filter.

Quick guide: remove duplicates from Excel

1. Select all of the cells that you want to remove the duplicates from.
2. In the " Data " tab, click on " Remove duplicates ".
3. A new window is opening up. Here, select all the columns from which duplicates should be removed and then click " OK ".
4. After a successful deletion process, a pop-up will open that tells you how many values ​​have been deleted and how many will be retained. Click on " OK " to close the window.

---