How to Remove Duplicates with Advanced Filter or Power Query (Excel 2013 or above)
Channel: Efficiency 365 by Dr Nitin
Date: 2016-03-22

Removing Duplicates is a built-in feature in Excel. But most of us want to see what is going to be removed. Clear all your doubts and learn the right method using either Advanced Filter or Power Query.

Key video timings:

Intro (00:00:00)
What Excel thinks and what you assume when it comes to remove duplicates (00:00:14) 
Excel's Remove Duplicates option (00:00:29)
How to remove duplicates using Advanced Filters Unique Records Only (00:01:25) 
How to see hidden, duplicate rows (00:01:40)
How to Remove Duplicates using Power Query (00:03:42)
What is the difference between Remove Duplicates option in Excel and Remove Duplicates Option in Power Query? (00:04:39)

This tutorial is explained by Dr Nitin Paranjape - Office MVP in his unique, common-sense based style. Learn more and become efficient at http://efficiency365.com