How to filter out rows with duplicate content in Excel: digWin

digWin is a collaborative platform for techies, mostly Microsoft stories and comments shared by the community.

home » Security » Windows Security » How to filter out rows with duplicate content...

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 filter2. Data | Filter | Advanced Filter3. 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 tit

posted by hjwin (63) in Windows Security 27 months ago email this leave a comment

Related News/Blogs

How to filter out rows with duplicate content in Excel - blogs.technet.com

FileSystemWatcher generates duplicate events - How to workaround - blogs.msdn.com

Configuring the ISA Server 2006 HTTP Filter - www.ISAserver.org

duplicate - www.vistax64.com

Update for Outlook Junk E-mail Filter (January 2009) - msmvps.com

I want to reference a parameter (twice!) in a formula filter condition - blogs.msdn.com

Comments

Be the first to post a Comment!

Post voted by 1 digWinners

hjwin (63)

Featured

Subscribe for Free!

Recommended MS community

home » Security » Windows Security » How to filter out rows with duplicate content...