['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.', 'Click the OK button.']