How to Remove Duplicate Entries in Excel

  • MORE

hero

For a small spreadsheet, finding and removing duplicates is as easy as selecting and deleting each additional entry. For a large data set with hundreds or even thousands of names, the ability to remove duplicate entries in a semi-automated way could potentially save you days of hunting.

Today we’re going to create a small set of data, and remove duplicate entries through Excel’s own duplicate removal tools.

1. Open an Excel workbook, or create a new one if you want to follow along. If there’s no existing data, you’ll have to add some dummy text to try this out yourself. For the sake of this tutorial, I just made a list of artists and bands, duplicating a few names along the way.

new

2. Select a column (or columns) to look for duplicated data. If you’re using a large data set, I’d recommend selecting each column individually. Often times, there’s a name in a different column that’ll match the first column, but won’t be a duplicate we need to remove.

select

3. Open the Data tab at the top of the ribbon. 

data

4. Find the Data Tools menu, and click Remove Duplicates

remove

5. Press the OK button on the pop-up to remove duplicate items from your data set.

ok

Add a comment
1 comment
Back to top