Remove Duplicates in Excel - Easy & Effective Method | Excel Hacks | Kovolff
Channel: prelearn
Date: 2021-01-30

In a previous video we built our own method to remove duplicates in Excel.
Video: https://youtu.be/_Vie6KlIOf0

In this video we will use the inbuilt Excel function “Remove Duplicates” in Data to effectively do the same thing.

1. Select the column you wish to remove the duplicates from
2. Click on the Data tab
3. Click on “Remove Duplicates”
4. Check the “My data has headers” checkbox if your data has headers
5. Click on OK

Duplicates get deleted, and Excel notifies you on how many duplicate values were removed and how many unique values are left.

#excel #hacks #learn