I need a VBA script that will take the keywords in column A, clean them and return the cleaned results in column C. See attached Excel file for what this might look like. The specific cleaning functions that would need to be performed on the keywords in column A are to remove any permutations caused by keyword phrases all containing the same exact words but listed in a different order and also clean any permutations caused by any of the words in a combination being plural.
For example, if these keywords were in column A:
Large Red Widget Size 8
Red Widget Size 8 Large
Widget Size 8 Large Red
Size 8 Large Red Widget
8 Large Red Widget Size
Red Large Widget Size 8
Red Large Widgets Sizes 8
Size 8 Red Large Widget
Size 8 Widget Red Large
Red Size Widget Large 8
Large Red Widgets Size 8
Sizes 8 Large Red Widget
Upon executing the Macro, the following cleaned list would be inserted in Column C
Large Red Widget Size 8
In this example, only the single keyword phrase, "Large Red Widget Size 8" would be inserted into Column C as all of other keywords in Column A are a variant of this single keyword phrase (including plural words of this single keyword phrase). This VBA function would need to be able to clean a list of up to 100,000 keywords in Column A. My budget for a fairly uncomplicated script like this is around $20 so keep this in mind when bidding your combination of your hourly rate x the exact number of hours it will take you to complete the script (should not exceed $20 or you will not be awarded this project, so if your hourly rate is $20/hour, don't bid more than an hour or if your hourly rate is $10/hour don't bid more than 2 hours, etc.). In addition I will need 24 to 48 hours to test the script after it is provided to me prior to releasing payment in full.
Good luck with your bid! :)
I have a clever solution...(that I doubt others will think of). However the fly in the ointment is the plurals. I can do this in place (without VBA). Can you think how? I will post the solution in a PM.
10 freelancers are bidding on average $17/hour for this job
Hi Bogarto. Thanks for posting this, it was a really interesting challenge! I've sent you a detailed PM with all of the relevant details for this tool. Looking forward to hearing from you.
Hi We are well experienced in this and we can do your task with 100% accuracy and on time and can start right away and complete it ASAP. Pls refer PM my skype id is babbypathak