Select the range of cells
Go to the Data tab
Click Advanced in the Sort & Filter group
Choose Copy to another location
Check Unique records only
Select the Copy to box
Click OK
Use the Remove Duplicates feature on the Data tab
Use the UNIQUE function in Excel 365 or Excel 2021
Use a PivotTable and place the field in Rows
Use Filter and select unique items manually
