How to Find Duplicates in
Click on any cell or in the dataset from which you need to eliminate copies.
Data tab → Data Tools segment → Remove Duplicates
Now click on OK.
Now you can see, the copy records are taken out.
For other Methods & advanced filter Options Tap on