Completed

Excel VBA Module - Keyword List Cleaner

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! :)

Skills: Excel, Visual Basic for Apps

See more: vba keywords list, excel vba keywords list, excel vba keyword list, list vba keywords, vba keyword list, vba keywords, excel vba keywords, excel list cleaner, vba keyword, excel hourly rate, what is vba in excel, what is vba, what is macro in excel, me vba, excel vba with, excel vba or, excel vba and, excel 2013 vba, vba excel macro, test applications

About the Employer:
( 17 reviews ) Riverview, United States

Project ID: #4516215

Awarded to:

askPaul

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.

$15 USD / hour
(4 Reviews)
2.5

10 freelancers are bidding on average $17/hour for this job

Teloquence

Consider it done. Check your PM for my bid details.

$20 USD / hour
(321 Reviews)
7.6
psprongs

Hi, I have working experience in VBA programming. I can provide a simple and straightforward VBA script in an hour. Regards, psprongs

$20 USD / hour
(11 Reviews)
4.5
excel4engineers

Please refer to my private message to get my exclusive offer.

$15 USD / hour
(23 Reviews)
4.0
ramanujana

Hi, I am an IT professional with 10+ years of experience in the MS Office VBA programming. I can work on this project and will get started immediately. Will deliver in a day. Please let me know if you are intereste More

$15 USD / hour
(10 Reviews)
3.6
pddonnelly

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.

$20 USD / hour
(3 Reviews)
3.8
mpunn2007

Hello, I can do it.

$15 USD / hour
(7 Reviews)
3.0
Rajmohan007

Hi This is a simple task, pm me asap, so i will send within the day Thnks Raj

$22 USD / hour
(6 Reviews)
2.7
BCSoft

10+ years of experience in software development

$15 USD / hour
(1 Review)
1.7
babbypathak

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

$16 USD / hour
(0 Reviews)
0.0