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.

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

    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

    You must be logged in to post a comment.