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 –
Previous Tutorial: How to Find a Perfect Category and Subcategory for your Ad Posting job?
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 link in a descriptions or discuss more on 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 they 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
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 classified sites list and select the entire column to remove duplicate. Now go to 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 be 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 content duplicate! So Copy first part of your classified sites list to Cell A1 column and leave the next column B1 and paste 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’s or Duplicate domain.
Inspire From Your Search: Ad posting job Review : How I Made 65,000 from India?
There is both Pros, Cons are in bulkseotools.com , you can use this Utility website to remove duplicate ad posting websites list with in second but it has limitation of remove duplicate value only form 500 classified sites list. So if you have less than of 500 classified sites list you can use this website as a 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.
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.
Latest posts by Anirban Karmakar (see all)
- 5 Must have Online Tools for Ad Posting jobs/Classified advertisement - February 18, 2017
- 10 Business Ideas that can be started in India with 50K investment - February 18, 2017
- Ad Posting Jobs: How to find post ads button in almost any classified sites? - February 17, 2017
- 180 (TESTED) Classified Ad Posting Sites List Without Registration - January 19, 2017