Compartir a través de

How to filter out rows with duplicate content in Excel

  • Artículo

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

  • Anonymous
    January 01, 2003
    The comment has been removed
  • Anonymous
    April 13, 2004
    That is the most amazing Excel tip ever! Thank you, thank you, thank you. Who knew it was there all along?

    --jason

  • Anonymous
    April 13, 2004
    Jason: Comments like yours make this so worthwhile :-) Thanks.
  • Anonymous
    April 13, 2004
    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)
  • Anonymous
    April 13, 2004
    John: Way ahead of you, man: http://blogs.msdn.com/kclemson/archive/2003/10/24/53879.aspx

    ;-)
  • Anonymous
    April 14, 2004
    Oh monkey pants.
  • Anonymous
    June 09, 2004
    Did not know you could do that,.....thanks much