you could look at the vlookup of match commands



"Madiya" wrote:

Hi all,
I regularly get one report file which I have to compare with my own.
Is there a array formula that will compare the 3 or 4 criteria for all
the rows and compare it with the new file which will give me the only
rows where criteria is not matching?

It is actually a negative list. All the records of two files will be
compared and only those records will be returned where criteria is not
matching.

It is a bit confusing but let me know if you need more info.

Any help is very much appreciated.
Regards,
Madiya.