Eliminating Duplicate Lines in an Excel Table

Excel is a great way to build tables of data, but sometimes you need to make sure you don’t have any duplicates in your data. That may be easy if you only have a dozen rows, but what if you have thousands?

It’s very simpleā€¦ use the Remove Duplicates menu option!

Here I have a table of ten data rows, four of which are exact duplicates. I can delete those using Table Tools > Design > Remove Duplicates:

original-spreadsheet-with-duplicates-20160623-1

Excel will ask you what columns you should use to compare duplicates. By default, it selects the entire row:

remove-duplicates-options-20160623-2

When you click OK, the duplicate rows are deleted and you now have unique table rows:

new-spreadsheets-without-duplicates-20160623-3

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s