The first link asks for login credentials.
This link shows me a sample file. The layout is what I thought it would be.
Ok, so tell me what result you're looking for?
Account # 1183-06, all the data matches so what result do you want ? If all
the data didn't march what result would you want?
--
Biff
Microsoft Excel MVP
"Jim" wrote in message
...
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