I have two lists in separate spreadsheets with two columns in common, an ID
and an amount. These are columns B and C in both lists.

The amounts in one of the lists are positive and in the other they are
negative.
There are more than one occurance of some IDs in both lists. One of these
delightful little many-to-many relations.

When I merge the two lists, sort them using the IDs and calculate subtotals
most of these add to zero. The number of items in each subtotal is not the
same and not known in advance.

It is only the lines that produce a subtotal different from zero, below or
above, that I want to keep.

Copying the view where only the subtotals are shown, using
specialcells(xlvisible) whould make the details of the subtotals I am
interested in dissapear. This is not an option since it is this hidden
information I want to extract.

Is there a reasonably easy way to solve this?
A solution could be a macro that would expand all subtotals that are not
zero, or one that would remove all rows making up any subtotal that is zero.

By the way, there may be rows where a single value is zero, but the subtotal
it is part of is not. These rows must not be delated.


Looking forward to any suggestions.

Thank you.