Microsoft Office Tutorials and References
In Depth Information
Removing duplicate rows from a table
Removing duplicate rows from a table
If data in a table was compiled from multiple sources, the table may contain duplicate
items. Most of the time, you want to eliminate the duplicates. In the past, removing
duplicate data was essentially a manual task, but it’s very easy if the data is in a table.
Start by selecting any cell in your table. Then choose Table Tools Design Tools Remove
Duplicates. Excel opens the Remove Duplicates dialog box shown in Figure 19.6. The dialog
box lists all the columns in your table. Place a check mark next to the columns that you
want to be included in the duplicate search. Most of the time, you’fill want to select all
the columns, which is the default. Click OK, and Excel weeds out the duplicate rows and
displays a message that tells you how many duplicates it removed.
FIGURE 19.6
Removing duplicate rows from a table is easy.
When you select all columns in the Remove Duplicates dialog box, Excel will delete a
row only if the content of every column is duplicated. In some situations, you may not
care about matching some columns, so you would deselect those columns in the Remove
Duplicates dialog box. When duplicate rows are found, the fi rst row is kept and subsequent
duplicate rows are deleted.
Data does not have to be in the form of a designated table to remove duplicates. To remove duplicate rows from a
normal range, choose Data ➪ Data Tools ➪ Remove Duplicates.
It’s important to understand that duplicate values are determined by the value displayed in the cell — not necessarily
the value stored in the cell. For example, assume that two cells contain the same date. One of the dates is formatted
to display as 5/15/2012, and the other is formatted to display as May 15, 2012. When removing duplicates, Excel
considers these dates to be different.
Search JabSto ::




Custom Search