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):
[url removed, login to view]:Dart_evader/Russian_1-1000
[url removed, login to view]:Dart_evader/Russian_1001-2000
[url removed, login to view]:Dart_evader/Russian_2001-3000
[url removed, login to view]:Dart_evader/Russian_3001-4000
[url removed, login to view]:Dart_evader/Russian_4001-5000
And the Spanish frequency list is here. Let's only do up to 5000 for now.
[url removed, login to view]: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.
14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön
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 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