Compare large amounts of data

[Edgars.Aronietis]

I have 2 material specifications - Old and New. In one excel file
The number of position and quantities in the file have changed
This is a smaller file. the second file has 6000 lines

https://failiem.lv/u/q3jkkbmk



what would be the quickest way to compare them and understand what has changed?

[mjr veverka]

For example with this very simple method - see attachment.
Ps.: I did not look into your files.

[Edgars.Aronietis]

Thank you!
But if you look in to files you will see that this is more complicated...