Hi,

I would appreciate any suggestions how to create a macro that deletes the rows with the same value in column A and the sum of values in column B equal to zero.

Example:
Column A Column B
AAA 50
BBB 100
AAA -50

I was thinking of using the worksheet function SumIf, but am not sure how exactly to do that.

Thanks.
Eduard