Records Matcher
This project involves two Excel 2003 files that must be matched together.
File A has 35000 records of quoted companies names that span over 35000 rows. Each record consist in four values that are ordered in four fields. Each field is a column of the file. The fields are: “CompanyID”, “Name 1″, “Country”, “Industry”. There is also a fifth field, “Sector 1″, that has no values.
File B can have many thousands of records, up to 60000. I provide just a sample file with about 6000 records. The records consist in two values: “Sector 2″ and “Name 2″.
So, this is the task: create a script or a macro or whatever you want that does the following:
a) for each record contained in File A, it will look after value of field “Name 1″ and then find the same value in the field “Name 2″ of File B
b) when such match if found, it will copy the value of field “Sector 2″ in File B to the corresponding record of File A in the field “Sector 1″
Attention: it can happen that the values of “Name 1″ and “Name 2″ are not exactly the same. They can differ how the order of the word is (as an example: Name 1 = John Smith Name 2 = Smith John). They can also be different in terms of capital letter used (John versus JOHN).
There can also be differences because one word or sign my be missing either in value of field “Name 1″ or in value of “Name 2″…
So this means that the match must be done with INTELLIGENCE…as much as a human would be…
THIS UTILITY SHALL BE FINISHED IN NOT MORE THAN 8 HOURS FROM POSTING THIS PROJECT.
Who is capable ???
Thank you for bidding
