I will give you (1) a list of sentences, (2) a list of words.
You need to find an exact match of the words provided in the sentences (1) with the list of words from (2).
In other words, I want to know which and how many exact words from the sentences match the words from list (2).
In the end, you need to provide me with a single EXCEL sheet that in Column A has the list of words (one word per row) from (2) and in column B it shows "yes", if the word has been used. Any extra words not used from list (2) you can add into a new spreadsheet so I know which words don't match from the sentences. The list should be displayed in the same order as the wiki frequency list.
I have attached the sample sentences in russian and in spanish. The frequency list for russian is located here (up to 5000):
[login to view URL]:Dart_evader/Russian_1-1000
[login to view URL]:Dart_evader/Russian_1001-2000
[login to view URL]:Dart_evader/Russian_2001-3000
[login to view URL]:Dart_evader/Russian_3001-4000
[login to view URL]:Dart_evader/Russian_4001-5000
And the Spanish frequency list is here. Let's only do up to 5000 for now.
[login to view URL]:Frequency_lists#Spanish
// it would be nice to set this up so i can do this automatically with other sentence/word lists, but that's a bonus task.
// The words are in russian but since we are matching exact words you don't need to be able to read in russian.
We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!!
Please have a look at our message in your PMB.
Dear Customer,Greetings:):) We will be highly obliged to get an opportunity to work for you. My reviews on freelancer.com speaks about my credibility. I would love to start right away and can assure outstanding quality delivery in a timely fashion. An exciting proposal is waiting for you in your Inbox here. Please manage some time to check the Inbox for our samples & bid details.
Regards,
Crispy
Hello!
I would like to collaborate with you in this interesting project.
Please check your PM - I attached for you a simulation of job.
If you are interested to work with my method, please tell me.
Have a nice day!
Dear Employer
I have viewed your project details, and it has called my attention, and I am willing to work on it. Please take the time to check my private message for details.
Best regards
Hello Sir. I am a new freelancer here. And I am interested for the job. I assure you that I can easily work for the project. I have all the qualification based on the project posted. Please highlight my bid. Thanks..
Regards,
Jay Ar