If you don’t want to delete duplicate entries, you can simply highlight them with a bright color to review later.
Highlighting Duplicates
- Select the column or range of cells you want to check.
- Go to the Home tab.
- Click Conditional Formatting > Highlight Cells Rules > Duplicate Values.
- Choose a color scheme from the dropdown and click OK.