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).

	Employee ID	Department	Salary
Source A	100	10	600
Source B​	<strike></strike>100	20	600
Source A​ <strike></strike>	<strike></strike>110	40	300
Source B​ <strike></strike>	<strike></strike>110	40	350
Source A​ <strike></strike>	<strike></strike>120	50	550
Source B​ <strike></strike>	<strike></strike>120	50	600
Source A​ <strike></strike>	<strike></strike>130	70	700
Source B​ <strike></strike>	<strike></strike>130	80	700

<tbody>
</tbody>

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.