Click the Advanced Filter button on the Data tab of the Ribbon.
Select the “Copy to another location” radio button.
Select the “List range”. The range/column that contains the duplicate values.
Select the “Copy to” range. ...
Click the “Unique records only” checkbox.