Select the range of cells
Go to the Data tab
Click Remove Duplicates to keep only unique entries
Use the UNIQUE function in Excel 365 or Excel 2021: `=UNIQUE(range)`
Use Advanced Filter
Select the range
Go to Data tab
Click Advanced in the Sort & Filter group
Choose Copy to another location
Check Unique records only
Click OK
Use Conditional Formatting to highlight duplicates before filtering
Use PivotTable to list unique values
Insert a PivotTable
Drag the field to Rows
Copy the resulting unique list if needed