Select the range of cells
Go to Home
Click Conditional Formatting
Choose Highlight Cells Rules
Select Duplicate Values
Pick a formatting style
Click OK
Use Remove Duplicates on the Data tab to delete duplicate entries
Use COUNTIF to identify repeated values
Use PivotTable to summarize duplicates
Use Filter or Sort to group duplicate values together