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


--
chom
------------------------------------------------------------------------
chom's Profile: http://www.excelforum.com/member.php...o&userid=25665
View this thread: http://www.excelforum.com/showthread...hreadid=390810