How to Find Duplicates in Excel

Step 1. Click on any cell or in the dataset from which you need to eliminate copies.

Step 2.  Click on  Data tab → Data Tools segment → Remove Duplicates

Step 3. Now click on OK.

Step 4. Now you can see, the copy records are taken out.

For other Methods & advanced filter Options Tap on Swipe up