How to Remove Duplicate Domains in Google Sheets - WebDesy.com
You can read the post here
http://webdesy.com/delete-duplicate-d...
Here's the code mentioned in the video:
=IF(ISERROR(FIND("//www.",A2)), MID(A2,FIND(":",A2,4)+3,FIND("/",A2,9)-FIND(":",A2,4)-3), MID(A2,FIND(":",A2,4)+7,FIND("/",A2,9)-FIND(":",A2,4)-7))
You may need to delete duplicate domains when you do competitor research and your competitors have backlinks from the same domains or the same competitor has multiple backlinks from the same domain. This article will walk you through the whole process step-by-step so that you get a list of backlinks (one link per unique domain).
Links:
Blog post with the video on WebDesy.com: http://webdesy.com/delete-duplicate-d...
SEO Crash Course for WordPress Users: http://webdesy.com/products/seo-crash...
Don't forget to subscribe! / @vitaliykolos9902
The channel is all about making SEO visual. There's are lots of SEOs or inbound marketers out there who are having a hard time figuring out how to build or earn links for their respected sites. This channel will make it obvious and easy to follow.