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?
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.