How to compare whole table against another one and find differences?

asked 2016-12-18 21:46:34 +0100

Edmund Laugasson gravatar image

For example there are two different tables (e.g. table A and table B) with many columns consisting some rows that are matching. There is a need to find non-common part from table A and also from table B by keeping whole row consistency and comparing whole row. What matching rows exist in table A but not in B and also what matching rows exist in table B but not in A. Result should be two tables with differences. At the same time keeping whole row consistency. I've found some hints how to compare cells but not whole rows in table (Q11233, Q18393). Would like to solve it in Calc but if it would be better do e.g. in Base then what would be the solution?

edit retag flag offensive close merge delete