Thread: Match help
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Match help

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