Removing Duplicates in Excel- Advanced Filter

Please sign up for the course before starting the lesson.

A useful tool to remove duplicates is the Advanced Filter which is based on the Filter but allows for filtering in place or else creating a copy of the data set without the duplicates.

Whereas the normal Data Filter struggles to show you the duplicates without you manually going through every one, the Advanced Filter will identify and extract them for you.

Back to: Data cleanup in Excel > Identify and Remove duplicates in Excel