"chom"
wrote in message
...

How to compare values in a colum that has several data of positive
and negative numbers, of which most of them cancel one another.
What I am trying to do is to delete all the numbers that cancel each
other and have obly numbers that are not cancel left in that column.

Column A
123
-123
-325
325
123

from the example above, after I successfully delete all numbers that
offsetting each other, I should have only $123 as a total in column
A

Please help. Thanks Chom


Hi Chom,

See my reply to your other post. If that doesn't work, reply there.

Multiple posts are bad form - stick with one thread and follow a
discussion of suggestions there.

HTH,

Alan.