Compare data in the rows per every ID code, with the rows of another file to see differences

[adrig]

Hello Team,

I have a spreadsheet which its main data it is the ID, it represents an employee position, which can be repeted during the column. I would like to compare,
for each of the IDs, the data in the row of that ID with another excel sheet to see if they are the same or if there are differences.
For example to know if the ID "code" 43000000 matches all the data of its row (each of the columns of its row) with the same ID in another Excel sheet, to see if there are differences, and if so highlight them to know what they are.

Is it possible to achieve this with excel?

compare this tab

with this tab:

What would be the formula?


Best regards

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Compare data in the rows per ID code, with the rows of another file to see differences
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[adrig]

Hello,
Yes, i crossposted in excelforum

Compare data in the rows per ID code, with the rows of another file to see differences

Hello Team, I have a spreadsheet which its main data it is the ID, it represents an employee position, which can be repeted during the column. I would like to compare, for each of the IDs, the data in the row of that ID with another excel sheet to see if they are the same or if there are...

www.excelforum.com

Regards