To compare to tables of data

Hi

I have a challenge for real excel professionals either a chance to prove yourself to be one.

Here is my problem:

I have to compare two lists consisting of several columns each for the monthly report. The data may be identical in both lists except for on cell in the string.

I want to have some sort of formula in between those lists which can tell me that I have new row in new list either some row is missing comparing to the previous month.

Maybe some one has already done something like this?

Does this help?

I have assumed (for simplicity) that each list contains just 2 columns,
it should be reasonably evident how to expand this to more.

List 1 is in columns A and B List 2 is in columns D and E

In cell G1 type in:

=IF(AND(ISNUMBER(MATCH(A1,D:D,0)),ISNUMBER(MATCH(B1,E:E,0))),"","Deleted")

In cell H1 type in:

=IF(AND(ISNUMBER(MATCH(D1,A:A,0)),ISNUMBER(MATCH(E1,B:B,0))),"","Inserted")

Replicate these 2 cells down.

Basically column G checks each row in the first list to see if it exists in the second list
if it does not then it must have been deleted.
Column H checks each row in the first list to see if it exists in the first list,
if it does not then it must have been inserted.

Mark.