How to find and remove duplicate records from Microsoft Excel

I want to share a method to show and remove the duplicate records based on your criteria.
Hope it's useful for you for working with your data, this method also applicable for Google Sheet via "Data", then "Remove duplicates" as well.
But for Libre office, you may have to use the "Standard filter" with the option "No duplicate"

Timestamps
0:00 Introduction
0:12 Sample data
0:23 Show duplicate using conditional formatting
0:45 Let's remove duplicate records
0:57 Result of using 4 columns
1:13 Result of using 3 columns

#Excel #RemoveDuplicate #Dedup