Leave only differing cells

asked 2018-08-10 23:11:25 +0100

Sabhotep gravatar image

I have a file (table) and its new version with 11486 new rows and some changes to some of the existing 108408. How to delete same rows so that only modified/new ones are left?

edit retag flag offensive close merge delete


New and modified rows are in the new file version? There is a date or similar data to discriminate between old and new rows?

There is a value unique to each row (e.g. name, part number) that remains the same in the changed rows?

Maybe Pivot Tables could help.

Add Answer is reserved for solutions. Please, click edit below your question if you want to add more information.

LeroyG gravatar imageLeroyG ( 2020-12-25 17:19:26 +0100 )edit