Today on this page we will teach you how to find and remove duplicate entries. Excel’s duplicate formula is useful because when you make a duplicate entry. So it helps us to find and delete that duplicate entry.
So let’s learn it
Here you can see some entries in the excel sheet. Now we have to find duplicate entries and delete them. With this, you can remove duplicate entries in a pinch. You will be able to do your work smarter so that you will not have much trouble.
Remove Duplicate Entries
First Step: Highlighting Duplicate Entries
Select All Entries
Conditional Formating – Highlight Cells Rules – Duplicate Values
Now here you can see a popup of Duplicates Values click on the OK button. Or you can also select the color according to your comfortable in it. Now you can see all duplicate entries.
Second Step: Remove Duplicate Entries
First of all, select the whole entries and then click on the Data now you can see Remove Duplicates click on it.
You can see a Popup of Remove Duplicates
You see all columns of your entries. Uncheck the one you don’t want to delete.
Click on OK button
Now all duplicate data is deleted
Thank You – Visit Again our Excelkeys Page