How to filter out rows with duplicate content in Excel

If you have data in Excel and you want to hide rows with duplicate entries, it's super easy:

1. Select the data you want to filter
2. Data | Filter | Advanced Filter
3. Click “Unique Records Only“

Excel will then hide rows that are duplicates of each other. I use this when putting together stats for the Exchange blog. At one stage in the process, I have a CSV full of rows with the article title and search terms used to get to that article. I want to let the authors of the blog know what terms were used to get to their articles, so I filter out the duplicate rows to make it more digestable.

Comments (7)

  1. Anonymous says:

    This blog entry on eliminating duplicate rows in Excel has changed my life… thank you, earnest looking Microsoft employee! Now why the fuck isn’t this in the help menu anywhere? I’m looking at you, Clippy….

  2. Jason says:

    That is the most amazing Excel tip ever! Thank you, thank you, thank you. Who knew it was there all along?


  3. KC Lemson says:

    Jason: Comments like yours make this so worthwhile 🙂 Thanks.

  4. John Eddy says:

    Another cool trick:

    If you want to do a quick count/sum/avg of some numbers, simply select them and look in the lower right at the status bar. If you don’t want whatever its showing you (eg, it shows you sum and you want avg, right click it)

  5. John Eddy says:

    Oh monkey pants.

  6. Cindy says:

    Did not know you could do that,…..thanks much

Skip to main content