Hello Alan,

I can't find your reply to my other post. Can you help me again, please?
Here's my sample:
752.00
(752.00)
852.00
(852.00)
(852.00)
5.00
Thank You, Chom
"Alan" wrote:

"chom krusopon" <chom
wrote in message
...

I have a total column that contains several positive and negative
numbers that offset one another. Example:
Total
123
523
153
-523
-123
Is there a way to write a formula so that excel will delete all the
numbers that wash each other and leaves only numbers that are stand
alone. From the example above it will be $153. Please help ASAP. I
have a big worksheet that has well over 1,000 roles of mixed numbers
that I need to delete. Thank YOu, chom


Hi Chom,

See my reply to your other post.

If that doesn't work, reply back there.

Alan.