Question: how to copy a column and paste only the unique records in excel?
Answer: 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.