Remove Duplicates Excel 2008 How To Remove Duplicate

It can be seen that the duplicate value Laura CARTER has been removed from the list.

Remove Duplicates Excel 2008 How To Remove Duplicate

Note that these methods show how to remove duplicate cells from your spreadsheet.

If you want to find and remove entire rows that are duplicated, see the Remove Duplicate Rows in Excel page.

Remove Duplicate Cells in Excel For each of the methods decribed below, we use the above simple spreadsheet on the right, which has a list of names in column A.

We first show how to use Excels Remove Duplicates Command to remove duplicates and then we show how to use Excels Advanced Filter to perform this task.

Finally, we show how to remove duplicates using the Excel Countif Function.

Remove Duplicates Using the Excel Remove Duplicates Command The Remove Duplicates command is located in the Data Tools group, within the Data tab of the Excel ribbon.

To remove duplicate cells using this command: Select any cell within the data set that you want to remove the duplicates from, and click on the Remove Duplicates button.

You will be presented with the Remove Duplicates dialog box shown below: This dialog box allows you to select which columns of your data set you want to check for duplicate entries.

In the example spreadsheet above, we only have one column of data (the Name field).

Excel will then delete the duplicate rows, as required and will present you with a message, informing you of the number of records removed and the number of unique records remaining (see below).

The resulting example spreadsheet is shown on the right above.

As required, the duplicate cell A7 (containing the second occurrence of the name Laura CARTER) has been removed.

Note that the Excel Remove Duplicates command can also be used on data sets with multiple columns.

An example of this is provided on the Remove Duplicate Rows page.

Remove Duplicates Using the Excel Advanced Filter The Excel advanced filter has an option that allows you to filter unique records in a spreadsheet and copy the resulting filtered list to a new location.

This gives you a list that contains the first occurrence of a duplicated record, but does not contain any further occurrences.

To remove duplicates using the Advanced Filter: Select the column(s) to be filtered (column A in the example spreadsheet above); (Alternatively, if you select any cell within the current data set, Excel will automatically select the entire range of data when you activate 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 located in D ata F ilter menu).

You will be presented with a dialog box showing you the options for the Excel advanced filter (see below).

Within this dialog box: Select the option C o py to another location; Make sure that the range that has been entered into the L ist range: field is correct; In the Copy t o field, enter the location that you want to copy the new list to.

Note that this location must be in the current worksheet.

In this example, cell C1 of the current Worksheet Sheet1 has been selected as the copy to location); Check the Unique r ecords only box; Click OK.

The resulting spreadsheet, with the new data list in column C, is shown on the right above.

Remove Duplicates Excel For Mac 2008