From the course: Excel 2016 Essential Training
Unlock the full course today
Join today to access over 23,200 courses taught by industry experts.
Removing duplicate records
From the course: Excel 2016 Essential Training
Removing duplicate records
- If you work with lists of data, and particularly if a list has been worked on by different people, and you're getting data from different sources, you sometimes encounter the problem of duplicate records. And on this worksheet called "RemoveDuplicates," we're seeing, for example, in rows 5 and 6, the same data, exactly, all the way across. We also have two Thomas Allens, but those are actually different people, and you can see the data. Now, when you find one of these, of course you're going to get rid of the data. The worry is, how many others do we have? The feature I'm about to show you, called "Remove Duplicates" doesn't require that the data in question, for example these two, they don't have to be adjacent to one another. They could be widely dispersed. You're likely to see them because you sorted the data and you see one here. But who has time to go through a potentially huge list here? As I double click the bottom edge of this cell, we see it goes down to row 743. Let's go…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
-
-
(Locked)
Sorting data9m 44s
-
(Locked)
Inserting subtotals in a sorted list8m 39s
-
(Locked)
Using filters6m 43s
-
(Locked)
Splitting data into multiple columns8m 26s
-
(Locked)
Splitting and combining columnar data with Flash Fill6m 40s
-
(Locked)
Removing duplicate records2m 23s
-
(Locked)
Using validation tools10m 45s
-
(Locked)
-
-
-
-