So you are doing online ad posting jobs for a company or either for your personal interest, no matter the reason for your ad posting but you should always agree that finding duplicate classified sites list is always painful to you. So here I am going to lead you the smartest ways to Remove Duplicate ad posting websites while doing ad posting jobs. Let get started –
Recommended Read: Ad Posting Jobs: How I Earned Rs-165,800 in a month?
5 Tricks to Remove Duplicate ad posting websites:
In this tutorial, we are going to use classified sites list and few of tools and excel tricks. If you don’t have such you can easily download from the link in descriptions or discuss more on the comment section.
1. Using duperemove Tools:
This a free tools by scrapebox.com, you can download it from CYBER EXPO or from here. and use it for free. You don’t need to set up this tool into your computer, just open and scroll to the middle of remove duplicate URS’s or domain. Now you have to select source file (must be in .text format) and now select target files and give a path to save your output result. Give file name (example- output.txt) and click on save. Now scroll below and you can able to find two buttons, 1. Remove Dup URL 2. Remove Dup Domain. If you are doing ad posting jobs then it’s recommended that you click on Remove Dup Domain, and if you want to remove only the Duplicate URL’s not the domain then you should click on Remove Dup URL. Hence its take only a second to process your files and a new file output.txt (Your source file name) will be generated by duperemove tools. Open and use this files and now it has no Duplicate ad posting websites.
Recommended Read: 5 Creative Ways to Make money from Ad Posting Job
14 ad posting Tips & Tricks That will Help You to Post 2000 Classified Ads
2. Conditional Formatting in Excel:
If you are using MS-excel 2010 or higher you can find Conditional Formatting into your excel home menu. Now Copy all of the classified sites lists and select the entire column to remove duplicate. Now go home, and then click on Conditional Formatting → Highlight Cells Rows→ Duplicate value. Now you can see that all the entries with Duplicate URL are highlighted. Now simple remove duplicate ad posting websites and enjoy your ad posting without trouble.
Tips: Its will save your lot of time if you can short your ad posting websites list before using Conditional Formatting in Excel, Additionally if you want to remove duplicate domain also instead of duplicate URLs they first Remove, Http://, www. And page Slug before processing to Conditional Formatting.
3. Using MS-Excel Formula:
We have two formulas that you can apply to remove duplicate URLs from your ad posting websites.
=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))
Using this Excel Formula will not need to change anything, just put your entire classified sites list on your excel A2 column and paste this formula’s code to A2. Now drag and see the result.
Or You can use this =IF(ISERROR(MATCH(A1,$C$1:$C$26,0)),"",A1)
Using this excel formula is as easy as previous. You can compare two lists here. Like, suppose you have two classifieds sites list and you want to compare which one is a content duplicate! So Copy first part of your classified sites list to Cell A1 column and leave the next column B1 and paste the second part of your classified sites list to Cell C1 column. That’s it. Now paste mention formula to the B1 Cell and drag it. Now you can see the transparency and fundamental compare of both this two list. Now you can easily identify the duplicate URL or Duplicate domain.
Inspire From Your Search: Google Ad posting Jobs Without Investment – FREE Sign Up Today!
There are both Pros, Cons are in bulkseotools.com , you can use this Utility website to remove duplicate ad posting websites list within second but it has the limitation of remove duplicate value only from 500 classified sites list. So if you have less than of 500 classified sites list you can use this website as the quickest way to remove duplicate. Click this link and paste your entire classified sites list and submit. Now sit back and relax while bulkseotools.com will work for you. After finishing your request you can able to copy output result into your clipboard and here you go.
Next Tutorial: How to use Alexa Traffic Rank toolbar for doing ad posting jobs smartly?
So which is now your favourite? Do you have any more tricks that work similar to Remove Duplicate ad posting websites. Please let me know your comment.
Next Article to Read: