Hi All,
I am trying to compare two excel workbooks using excel formula. The data in both the excel workbook is not same always.
Example:
Excel workbook1 has the below columns and the data
Task Name Job Department Wing Shift Hours Cost
Assign Wing 1 Joe Technician ABC Wing 1 Day 10 100
John Tech level I IT Wing 1 Night 20 120
30 220
Assign Wing 2 Mary IVR 1 XYZ Wing2 Evening 100 100
Iris IVR2 DDD Wing1 Day 20 20
120 120
Excel workbook2 has the below columns and the data
Task Name Job Department Wing Shift Hours Cost
Assign Wing 1 Joe Technician ABC Wing 1 Day 50 100
John Tech level I IT Wing 1 Night 10 100
Pete Tech level 3 IT Wing2 Eve 10 100
70 300
Assign Wing 2 Mary IVR 1 XYZ Wing2 Evening 100 100
Iris IVR2 DDD Wing1 Day 20 20
120 120
Assign Wing 3 Fran IVR3 CCC Wing3 Day 100 250
100 250
In the above example if you see workbook values differs, Workbook 2 Assign wing 1 has 3 rows where as workbook1 has only 2 rows and also there is new row in workbook2 for assign wing3 which is not present in workbook1.
The mismatches can be in either of the excel sheets if this is the case how will I find the difference in data as well as matching data between both the excel sheets. Please help me out.
Thanks,
I am trying to compare two excel workbooks using excel formula. The data in both the excel workbook is not same always.
Example:
Excel workbook1 has the below columns and the data
Task Name Job Department Wing Shift Hours Cost
Assign Wing 1 Joe Technician ABC Wing 1 Day 10 100
John Tech level I IT Wing 1 Night 20 120
30 220
Assign Wing 2 Mary IVR 1 XYZ Wing2 Evening 100 100
Iris IVR2 DDD Wing1 Day 20 20
120 120
Excel workbook2 has the below columns and the data
Task Name Job Department Wing Shift Hours Cost
Assign Wing 1 Joe Technician ABC Wing 1 Day 50 100
John Tech level I IT Wing 1 Night 10 100
Pete Tech level 3 IT Wing2 Eve 10 100
70 300
Assign Wing 2 Mary IVR 1 XYZ Wing2 Evening 100 100
Iris IVR2 DDD Wing1 Day 20 20
120 120
Assign Wing 3 Fran IVR3 CCC Wing3 Day 100 250
100 250
In the above example if you see workbook values differs, Workbook 2 Assign wing 1 has 3 rows where as workbook1 has only 2 rows and also there is new row in workbook2 for assign wing3 which is not present in workbook1.
The mismatches can be in either of the excel sheets if this is the case how will I find the difference in data as well as matching data between both the excel sheets. Please help me out.
Thanks,
