Removing Duplicates in Excel- Advanced Filter

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: