also a web page link if you prefer:
http://spreadsheets.google.com/pub?k...NmTctL5Rkujg7Q



"T. Valko" wrote:

Let's see if we understand this:

Report 1

......A.....B...C...D...E...F...G...H
......x......1....1.........1...1....1......

Report 2

......J.....K...L...M...N...O...P...Q
......x....1....1......................1.......

I need to be alerted if any of the data is different.

Ok, what result do want based on the above?


--
Biff
Microsoft Excel MVP


"Jim" wrote in message
...
Hello,

Report One
In Column A I have account numbers from one report,
In Column B:H is the data that I'm counting.
Each column has headers. Not all cells have data returned, but when it is
returned it shows a 1.

Report Two
In column J I have account numbers from the second report
In Columns K:Q is the data that I'm counting
Each column has headers. Not all cells have data returned, but when it is
returned it shows a 1

What I need help with, is matching column A and J and then matching
columns
B:H and K:Q. I need to be alerted if any of the data is different.

I hope this is clear. And thank you very much for the help.
Jim