SergioCM92
New Member
- Joined
- Apr 14, 2021
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
Good morning/afternoon everybody!
So here I have a really big problem: I have to make comparison cell by cell in a lot of bill of materials for yesterday. Totally impossible to do it manually.
I tried with formula's but cannot get any result.
Here's the trouble:
I have to compare rows, cell per cell, between two excel documents.
I have to tell which cells have been erased, which added and which changed from a version to another.
Then mark them as erased from the previous version (red), added in the newest one (green) and changed (orange).
The structure would be like this, comparing from left until blank cell in the right limit.
Each document 800 rows, 9 columns. Comparison between 16 documents (1 to 1 but eight times). As you can see I'm totally screwed.
I tried to copy both versions in a third document (report of comparison), focusing only in the sheet of the documents where the materials appear, using VLOOKUP, but no results, only showing which ones are new.
Do you have any method to search for the similitude from the left cell and then compare value per value until the blank right cell and mark them somehow?
I would say that the only unique value is the Mechanical designator(column A). The rest can be duplicated.
If you have any advanced trick here it would save me from the fire..
Thanks so much in advance!
So here I have a really big problem: I have to make comparison cell by cell in a lot of bill of materials for yesterday. Totally impossible to do it manually.
I tried with formula's but cannot get any result.
Here's the trouble:
I have to compare rows, cell per cell, between two excel documents.
I have to tell which cells have been erased, which added and which changed from a version to another.
Then mark them as erased from the previous version (red), added in the newest one (green) and changed (orange).
The structure would be like this, comparing from left until blank cell in the right limit.
Each document 800 rows, 9 columns. Comparison between 16 documents (1 to 1 but eight times). As you can see I'm totally screwed.
I tried to copy both versions in a third document (report of comparison), focusing only in the sheet of the documents where the materials appear, using VLOOKUP, but no results, only showing which ones are new.
Do you have any method to search for the similitude from the left cell and then compare value per value until the blank right cell and mark them somehow?
I would say that the only unique value is the Mechanical designator(column A). The rest can be duplicated.
If you have any advanced trick here it would save me from the fire..
Thanks so much in advance!