David_Baratheon
New member
- Joined
- Sep 11, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Version 2109 Build 16.0.1443
Hi everyone.
I have some data I need to compare in Excel 2010.
It looks something like this:
1 2 1 2 1 2
1 2 1 5 1 2
1 2 1 2 1 2
1 8 1 2 9 2
1 2 1 2 1 2
1 2 4 2 1 2
1 2 1 2 1 2
and it needs to be compared with:
1 2
1 2
1 2
1 2
1 2
1 2
1 2
These same two columns should be used to compare all 6 columns in the first piece of data. The 1 columns should be compared and the 2 columns should be compared.
As an output I need a list of all cells that don't match what they are being compared with.
Any suggestions on how I might achieve this?
I have some data I need to compare in Excel 2010.
It looks something like this:
1 2 1 2 1 2
1 2 1 5 1 2
1 2 1 2 1 2
1 8 1 2 9 2
1 2 1 2 1 2
1 2 4 2 1 2
1 2 1 2 1 2
and it needs to be compared with:
1 2
1 2
1 2
1 2
1 2
1 2
1 2
These same two columns should be used to compare all 6 columns in the first piece of data. The 1 columns should be compared and the 2 columns should be compared.
As an output I need a list of all cells that don't match what they are being compared with.
Any suggestions on how I might achieve this?