• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I remove duplicated lines


New Member
Hi, I was using a web scraping tool Octoparse to pull data off Yellowpages and read this post explaining how to remove duplicated data. But it only shows how to remove one column... Can I remove duplicated lines in other columns at one time?



Excel Ninja
Duplicated lines
... with which data?
... ... ALL or few columns?
>> Can You eg highlite with yellow colors
... which lines should remove? ... and why? = what is rule for remove?