One of the first tools to learn to remove duplicates is the Remove Duplicates tool. This tool allows you to easily remove the duplicates in a data set. It has the added advantage of being able to specify what is meant by a duplicate i.e. if one column is the same, or do multiple columns have to be exactly the same to qualify as a duplicate.
Removing Duplicates in Excel- Tool
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.