Join Dennis Taylor for an in-depth discussion in this video Remove duplicate rows from a list, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] On this worksheet,…and you can tell by its name what we're about to get at,…HR List Duplicates, we've got some duplicate records,…and that's a common problem when you work with lists,…particularly if different people have been involved…in updating the list, copying the list,…moving them back and forth and so on.…And very often, when you do see a duplicate record…you recognize it's adjacent to the current one.…Slightly different in this case, a little bit unusual,…but here's Susan Carr here in row two,…and down here, and I've got the Control key held down,…just for emphasis here, here's another Susan Carr.…
Now possibly it's the same last name,…but as you look up and down at the data,…I think you can see,…it's a duplicate record all the way across.…So, had we sorted this list by Employee Name,…these would have come together.…But the feature to get rid of duplicate rows…doesn't require that these be adjacent to one another,…although that often would be the case so,…we've got at least one record there that's been duplicated,…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes