In this tutorial, we will show to you the “how to” steps on finding the duplicate entries using the Microsoft Excel. This is really useful, in the case of checking duplicates in huge entries.
Launch the Microsoft Excel and paste the entries. Click on A1 to highlight all the entries.
Next, under Home, click on Conditional Formatting > Highlight Cells Rules > Duplicate Values.
As below example, you will see the duplicate entries will be highlighted in light red fill and dark red text. You can select the cells format from the drop down listings.
