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.