Merging two Excel files

Closed - This job posting has been filled and work has been completed.

Job Description


I am looking for a freelancer who can merge two Excel files. The task is quite simple. Have a look at an instruction as follows:

1. There are two excel files: "CRSP_CEF_Matched_Unique_3-27-2014.xls" and "FundNames_Holdings_Data_3-29-2014.xls" in the attachment.

2. Now compare the fund names of the former file (such as 'conm', 'comnam', 'Name') with that of the latter file ('fundname').

3. If they seem to mean same funds (i.e., same names with slight variations), please copy-paste the 'fundno' and 'fundname' to the former file.

4. As an example, I already filled up for some funds.

In order to do this work, you need to have some sense of English acronyms.


Open Attachment