Delete duplicate data in excel2003/2007

When you use Excel tables to block large quantities of data, you will inevitably find some duplicate rows and duplicate data, then we should delete those duplicate data, so as not to affect our work, in Excel to delete duplicate data and duplicate rows in the way there are more than N, Excel2003 Delete duplicate data and duplicate row methods:

1th Case: Duplicate row content exactly the same

As the following illustration shows, lines 2nd and 4th are identical:

Action method:

Select All records in the table (note that the header row for each column should also be selected at this point. Otherwise filtered data tables will no longer contain the header row, perform the data menu → filter → advanced filter command, and in the Advanced Filter dialog box that pops up, select the copy filter results to another location, and click Copy to the range button behind the selection box to select an area to hold the filtered data (note: Do not coincide with the original data in the cell, otherwise the data table will be confusing, and finally, check the "Select Not Duplicate Records" checkbox, click the "OK" button.

The details are shown in the following animation:

2nd case: Row and row, a column content repeat, other column content may be inconsistent

At this point we want to use a certain column to find the duplicate content and delete the entire row. As shown in the following illustration:

We only need a column (that is, the name column) without duplication.

Action method:

1, add new column E, enter the number of linear series (such as 1, 2, 3 ...), drag the manual handle can be.

2. Sort the whole table by a column.

3, in the F2 input formula: =if (A2=A1, "Repeat", "") drag the manual handle, the formula is copied down to the appropriate line.

4, all Select the table, "Data → AutoFilter", select F column "(blank)", so that there is no duplication of data.

5, copy the filtered table, paste the table into another worksheet.

6. Sort the whole table by e column, restore the original order of the data, then delete the E column.

The details are shown in the following animation:

Excel2007 Delete duplicate rows and duplicate data methods:

Now deleting duplicate data in Excel2007 is a very simple matter, and there is a "remove duplicates" feature.

Select the Data tab, and then click the Remove Duplicates button in the Sort and filter area.