I am currently working on a project whereby I need to remove duplicate rows (containing both a positive and negative number). I've tried a few different formulas and macros but I'm running into a problem. It's wanting to remove ALL positive matches instead of one.

For example: Column BH has -4,4,4,-2,2,-1,1,

I need it remove those numbers that cross cancel and keep the one that doesn't have a partner.

Can anyone help?

Side note: Column A has an owner code, Column B a well code, and BH is the amount due. I need it to bare this in mind as well. I hope someone knows how to make this happen.