Comparing 2 excel sheets which does not have same values

[Tester12]

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,

 

[Tester12]

In the previous thread the table values are not clear, updated table values here. Please help me out.

Excel worrkbook1 has the below columns:

Task <tbody> </tbody>	Name <tbody> </tbody>	Job <tbody> </tbody>	Department <tbody> </tbody>	Wing <tbody> </tbody>	Shift <tbody> </tbody>	Hours <tbody> </tbody>	Cost <tbody> </tbody>
Assign Wing 1 <tbody> </tbody>	Joe	Technician	ABC	WingI	Day	10	100
	John	Tech level I	IT	WingI	Night	20	120
						30	220
<tbody> </tbody>
Assign Wing 2	Mary	IVRI	XYZ	Wing2	Eve	100	100
	Iris	IVR2	DDD	WingI	Day	20	20
						120	120

<tbody>
</tbody>

Excel Workbook2 has the below columns

Task <tbody> </tbody>	Name <tbody> </tbody>	Job <tbody> </tbody>	Department <tbody> </tbody>	Wing <tbody> </tbody>	Shift <tbody> </tbody>	Hours <tbody> </tbody>	Cost <tbody> </tbody>
Assign Wing 1 <tbody> </tbody>	Joe	Technician	ABC	WingI	Day	50	100
	John	Tech level I	IT	WingII	Night	10	100
	Pete	Tech level II	IT	WingII	Eve	10	100
<tbody> </tbody>						70	300
Assign Wing2	Mary	IVRI	XYZ	Wing2	Eve	100	100
	Iris	IVR2	DDD	Wing1	Day	20	20
						120	120
Assign Wing3	Fran	IVR3	CCC	Wing3	Day	100	250
						100	250

<tbody>
</tbody>