HOW TO FIND AND HIGHLIGHTS DUPLICATES IN EXCEL
I will teach you how to find and highlights duplicates in excel
1. Select the cell or range which you want to check
2.Go to Home tab -> Styles -> Conditional formatting -> highlights cells rules -> Click Duplicates values
1 3. It will come like below, if you want to highlight the cells in different color here you can choose Values with cell otherwise give OK
4. I Clicked OK . Results shown as below
So all cells are duplicated except 2 will be unique cells which has highlighted in white.
Note: If you have more data to find duplicates you can choose the specific colors from the 3rd step then easily you can get count while you filter.
I think this will guide you how you can identify duplicates. Please comment if you have any doubt on this.