Leila Gharani – 3 Ways to Find and Remove Duplicates in Excel

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. Leila explains what the difference is and what to watch out for when using these methods.



This DigitalRosh item or Service is intended for DigitalRosh members

If you are not yet a member

Check Pricing & Sign up, and join us.

Sign up now and get 30 days free! Promo code: GIFT30

If you are a member

Kindly log in first to enjoy this item

Use one-click login

Or log in manually with your email