Select the range of cells you want to check
Go to Home
Click Conditional Formatting
Choose Highlight Cells Rules
Select Duplicate Values
Pick a formatting style
Click OK
Use Remove Duplicates from the Data tab to delete duplicate entries
Use the COUNTIF function to flag repeated values
Use Filter to show only duplicate records
Use PivotTables to count repeated items
Sort the data to group identical values together