How

In order to remove duplicate rows from Microsoft Excel you must first identify which rows contain duplicates.

To do this easily, follow the steps below:

• Sort the data by the column you think contains the duplicates. (in this case, column A)
• Insert a new column next to it (this is temporary. in this case, column B).
• Add an 'If' formula that compares the value in the cell next to it to the value immediately above it in the list. For example in cell B3 we would put, =if(a3=a2,"Dup","")

• Copy the formula down through the list.
• In the example above, row 7 will display "Dup" in column B, the rest will be blank
• Highlight the top row and select Data, Filter, AutoFilter.  This will create a dropdown list with choices that exist in that column.
• For column B, filter on "Dup"
• Highlight all the rows that remain visible (the non-duplicate rows will be hidden).
• Delete them.
• Take off the filter (select 'All' from the dropdown box).
• Sort the entire data set again to remove the blank rows.

And there you have it!  The easy way to remove duplicate rows from excel!