Row Data Compare

[blueolive]

Hello Friends, I have to do data compare from two data sources treating first data as correct and highlight any data point in the second data source that doesn't match the data point in the first data source.

Example - Any difference in source B row should be highlighted. The original excel has about 60 columns and 4000 rows. Looking for an automated solution (easy to implement/scale and reuse).

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Employee ID
[/TD]
[TD]Department
[/TD]
[TD]Salary
[/TD]
[/TR]
[TR]
[TD]Source A
[/TD]
[TD]100
[/TD]
[TD]10
[/TD]
[TD]600
[/TD]
[/TR]
[TR]
[TD]

Source B​

[/TD]
[TD]<strike></strike>100
[/TD]
[TD]20
[/TD]
[TD]600
[/TD]
[/TR]
[TR]
[TD]

Source A​

<strike></strike>
[/TD]
[TD]<strike></strike>110
[/TD]
[TD]40
[/TD]
[TD]300
[/TD]
[/TR]
[TR]
[TD]

Source B​

<strike></strike>
[/TD]
[TD]<strike></strike>110
[/TD]
[TD]40
[/TD]
[TD]350
[/TD]
[/TR]
[TR]
[TD]

Source A​

<strike></strike>
[/TD]
[TD]<strike></strike>120
[/TD]
[TD]50
[/TD]
[TD]550
[/TD]
[/TR]
[TR]
[TD]

Source B​

<strike></strike>
[/TD]
[TD]<strike></strike>120
[/TD]
[TD]50
[/TD]
[TD]600
[/TD]
[/TR]
[TR]
[TD]

Source A​

<strike></strike>
[/TD]
[TD]<strike></strike>130
[/TD]
[TD]70
[/TD]
[TD]700
[/TD]
[/TR]
[TR]
[TD]

Source B​

<strike></strike>
[/TD]
[TD]<strike></strike>130
[/TD]
[TD]80
[/TD]
[TD]700
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you!

 

[Peter_SSs]

Welcome to the MrExcel board!

Duplicate to https://www.mrexcel.com/forum/excel-questions/1106069-row-data-compare.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.