Remove duplicates using Excel's Advanced Filter

[sumaiyakhatun24]

This dialog allows you to select which columns in your dataset you want to check for duplicate entries. In the spreadsheet example above, we only have one column of data (the "Name" field). So we leave the "Name" field selected in the dialog box.
After you've made sure that the required fields are selected in the dialog box, click OK . Excel will then remove duplicate rows, as needed, and present you with a message telling you the number of records removed and the number of unique records remaining (see below).
Confirm Excel duplicate removal
The table resulting from the delete above the message is also shown. As requested, the duplicate cell A11 (which contains a second occurrence of the name "Dan Brown") has been removed.
Note that Excel's Remove Duplicates command can also be used on datasets with multiple columns. An example of this is provided on the Remove Duplicate Rows page.

There is an option in Excel's Advanced Filter that allows you to filter out unique record lebanon rcs data s in a spreadsheet and copy the resulting filtered list to a new location.

This provides a list that includes the first occurrence of a duplicate record, but no further occurrences.

To remove duplicates using the advanced filter:

Select the column or columns to filter by (column A in the example spreadsheet above); (Alternatively, if you select any cell in the current dataset, Excel will automatically select the entire data range when you enable the advanced filter.)
Select the Excel Advanced Filter option from the Data tab at the top of your Excel workbook (or in Excel 2003, this option is found in the menu Data → Filter ).