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 Introduction
00:36 Conditional Formatting
02:45 How to use COUNTIFS formula to find duplicate
05:08 How to Remove Duplicate

Let’s connect on social:
Instagram: [ Ссылка ]
Facebok: [ Ссылка ]
LinkedIn: [ Ссылка ]

#MsExcel

свернуть