PDA

View Full Version : How to compare data in Excel 2010



Dawud Beale
2013-09-11, 12:55 PM
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?

NBVC
2013-09-11, 03:36 PM
Crossposted:

http://www.excelforum.com/excel-general/954144-how-to-compare-data-in-excel-2010-a.html