3 EASY Ways to Find and Remove Duplicates in Excel

Microsoft Excel Tips and Tricks

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.

Credit Leila Gharani