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.

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. “Value” Excel Workbooks to lock in Values There are times when it is useful to remove all...
3. Paste Special - Transpose Excel Transpose...
4. Counting Visible Rows After Autofilter in Excel Typically when you use autofilter, the task bar at the...
5. Conditional Formatting Q: Dear ExcelYogi, Thank you for all your wonderful advise...