Finding the difference between two tables

[rufiqcavadov]

Hello everyone. I have 2 excel tables. Both tables are actually the same table, and they end at row 1696. Maybe they could change the quantity. Maybe they changed the quantity or the product names. I want to compare accordingly. I want to know what changes have been made to the entire table.

 

[Giordano Bruno]

Are the two tables in the same order? If not you would need to find a column filled with unique values and sort them both on that column, then place the two tables side by side. You could then use the array formula "=MAX(ROW(A:A)*(A:A<>M:M))". This will locate the last row in column A which does not equal what's in column M . Change the column letters to suit your situation and then copy the formula across the sheet. If there are no differences, the formulas will return 0. If a difference is found, note the cell and make it identical to the other table, then check the formula again. That's just one way.

 

[rufiqcavadov]

Are the two tables in the same order? If not you would need to find a column filled with unique values and sort them both on that column, then place the two tables side by side. You could then use the array formula "=MAX(ROW(A:A)*(A:A<>M:M))". This will locate the last row in column A which does not equal what's in column M . Change the column letters to suit your situation and then copy the formula across the sheet. If there are no differences, the formulas will return 0. If a difference is found, note the cell and make it identical to the other table, then check the formula again. That's just one way.

I didn't understand anything. I am so sorry.