There are many ways to remove duplicate rows in Excel, in this articles I will give you a quick and simple method of deleting duplicates using the Advanced Filter.

Assume you have data that contains multiple duplicate rows…

Select all the data that you would like to test for duplicates

Go to Data=>Filter=>Advanced Filter

Select the “unique records only” check box, then OK

Right click highlighted area and choose copy

Paste into another location

The pasted results will be only the unique rows of data from your original data set.

*Update*
There is now an add-in available through Subsidium Dashboard Consulting. The product is called Duplicate Deleter. It speeds up removing duplicates drastically and only cost .99 cents!

Joseph Harris
Excel Help

If you found this article helpful, buy me a cup of coffee!

Related posts:

1. Duplicates - Finding and Removing in Excel There are many occasions when you may need to remove...
2. Counting Visible Rows After Autofilter in Excel Typically when you use autofilter, the task bar at the...
3. Plug and Play Dashboard from ExcelUser Review Today I took a look at the Plug-N-Play Dashboards from...