Forum Discussion
agali2190
Oct 24, 2022Copper Contributor
Compare data in the rows per every 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 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?
- Nothing_Left_to_LoseBrass Contributor
Re: row comparison
'Professional_Compare' is a free workbook with multiple utilities.
The namesake utility will compare two worksheets cell by cell or row to row.
The results are provided on a new sheet that is added by the utility.(note: both workbooks must be open)
Download from OneDrive...
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
'---
Nothing Left To Lose