To compare to tables of data

[kucinskij]

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?