From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Removing duplicate records

Removing duplicate records - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Removing duplicate records

In this worksheet called Remove Duplicates, we've got duplicate records. Row six, row seven, that's Michael Adkins, same Building, same Department, everything is the same, that's a duplicate. We've got two Thomas Allens, but they're in different Departments, so different people there. We need to get rid of duplicates. A list like this doesn't have to be sorted but maybe that's how you've found a few. There might be another one down here somewhere else here; there is another one yeah, 47 and 48, Tim Beasley. But think of how painstakingly boring it's going to be if we start scrolling through this list looking for duplicates. And the list might be large. And by the way, you can get a quick read on the list if you simply click one of the column entries here. I'm clicking column C. What do we see in the Status Bar? Count 763 simply means we got 763 cells that have data in column C. We're also counting this, so we've got 762 rows below this. The list that we're about to use here does not…

Contents