Compare two files in Excel (by a general column)

Databases & SQL — incorrectly specified categories?

4 USD

Client's review of cooperation with Igor B.

Compare two files in Excel (by a general column)

4 USD

I am pleased with the cooperation with Igor.
He asked the right questions, which clarify the requirements and implement the project quality in time. I have created several versions of the macro, taking into account my comments.
We may be working on similar projects.

5.0

Valera Ivanov

Reciprocal Feedback

19 June 2016

Freelancer's review of cooperation with Valera Ivanov

Compare two files in Excel (by a general column)

4 USD

A great customer. Clear setting of tasks, immediate payment. Pleased with cooperation.

5.0

Igor B.

Reciprocal Feedback

19 June 2016

Project translated automatically. Log in or register, to view the original Good time for the day! Task: (see the attached files - then you can't read:) There are 2 files about 6k lines each. The column A in the first file corresponds to the column F in the second. It is necessary to create a third file in which: - Data from the columns A and B of the first file remains unchanged - Data from the columns D of the second file is in the columns C - Data from the columns A, B, C, E and F of the second file is in the columns D, E, F, G and H respectively - Data in the columns A and H coincide (possible initial and closing spaces are not taken into account) Since the file 1 contains less line than the file 2, for the remaining "excess" values: - Data from the columns H is copied into the columns A - the columns B remains unfilled. Thank you !

Update #1 from 18 June 2016

Виноват, недоглядел. Значения в столбцах A и H не буду совпадать, там чуть сложнее будет, но суть не меняется: ECA023 --> ECA0023

Applications3

XLSX

file 1.xlsx

119KB

XLSX

file2.xlsx

2MB

XLSX

SampleResult.xlsx

16KB