How to Remove Duplicate Entries in Excel 2016

In this tutorial, we’re going to show you how to remove duplicate entries in Excel 2016.


To get started, select the cells to remove the duplicates of. Then go under the Data tab and click Remove Duplicates. (There are limitations to the Remove Duplicates feature however. It registers an entire row as a single piece of data, so you cannot remove duplicates from two different columns. An example of this is illustrated later in this tutorial.)

Remove Duplicate Entries in Excel 2016

Then make sure the columns you want to remove duplicates from are checked. This takes all columns into consideration, so that Excel considers a duplicate an exact copy of the entire row. The Name, Recommendations, and Quarter must be the same value to be a duplicate. If only Quarter was selected, then rows with the same Quarter number only will be considered as duplicates.

Remove Duplicate Entries in Excel 2016

As you can see below, three duplicates were removed. If Quarter was the only column checked, then five columns would have been removed.
Here is an example of a limitation. Say I wanted to remove duplicates from both of the columns selected below. For example, Kiara would be removed from both columns. It wouldn’t work because Excel considers a whole row as a value.

Remove Duplicate Entries in Excel 2016

I can however, do the columns individually as shown below and remove Nikita for example.

Remove Duplicate Entries in Excel 2016

If you wanted to remove duplicates from both columns, you would need to put all the values in the same column.

Remove Duplicate Entries in Excel 2016