Select the range of cells or the table
Go to the Data tab
Click Remove Duplicates
Choose the columns to check for duplicates
Click OK
Use Conditional Formatting to highlight duplicates
Select the range
Go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values
Choose a formatting style
Click OK
Use the Advanced Filter to copy unique records
Select the data range
Go to Data > Advanced
Choose Copy to another location
Check Unique records only
Click OK
Use the UNIQUE function in Excel 365 or Excel 2021
Enter =UNIQUE(range) in a blank cell
Press Enter
Use Sort and Filter to show only unique values
Select the data range
Go to Data > Filter
Filter the column to remove repeated values manually