Subscribe!

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...

    This entry was posted on Monday, March 23rd, 2009 at 10:03 am and is filed under Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

    Leave a Reply