In this Excel tutorial you will teach yourself how to copy only unique records.
To copy just distinct list of values follow these steps.
Prepare list of data.
Go to the ribbon to the Data tab. Click Advanced button.
Filter to apply
Advanced filter window pops up. Fill fields in:
- tick Copy to another location
- List range is your data table. $A$1:$A$14 here
- Criteria range are criteria you like. It depends what you want to copy
- Copy to is the cell where you want to paste a header of your table
- tick Unique records only
Your unique list is copied.
This is a good way to copy only distinct values from your list. Excel will do it with just several your clicks.
In Excel, you can also copy only unique records by using the Remove Duplicates feature. Here's how to do it:
- Select the range of data that you want to copy and press Ctrl + C to copy it.
- Go to a new sheet in the same workbook or a new workbook and press Ctrl + V to paste the data.
- Go to the Data tab and click the Remove Duplicates button.
- In the Remove Duplicates dialog box, select the columns that contain the data that you want to check for duplicates.
- Click OK. Excel will remove any duplicate records and keep only the unique records in the paste area.
Note that the Remove Duplicates feature only checks for duplicates within the selected columns. If you want to check for duplicates across multiple columns, you need to select all relevant columns in the Remove Duplicates dialog box.
You can also use formulas or scripting to copy only unique records.