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
read more »
Be the first to post a Comment!