These are 3 easy ways to remove duplicates in your data to create a unique / distinct list of values in Microsoft Excel. It’s a very common task for data cleaning and also a very common job interview question. One of the solutions (removing duplicates with power query) returns a different result to the other methods. I’ll explain what the difference is and what to watch out for.

Timestamps

• 00:00 How to Remove Duplicate Values For Multiple Columns
• 01:15 How to Use the Remove Duplicates Feature
• 03:09 How to Use the UNIQUE Function
• 04:50 How to Use Power Query to Remove Duplicates
• 08:25 Wrap Up

#excel #developer