Hi,

I have 2 Excel files, or DBF files, I'd like to compare in order to return all rows which are different.

Is there any tools in Excel to do that?

But also, if there is a new row in the new file, in the middle of the others, how such a tool would work? Because, it could potentially return all the following rows because row 73 in file 1 (old file), for example, would become row 74 in file 2 (new file). It can happen if there is a new row 72 in the new file version...

Any suggestion?