Remove positive and negative duplicates

**mpinner** · 05-02-2014, 12:07 PM

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.

**mrice** · 05-03-2014, 10:49 AM

Try this user defined function

Please Login or Register  to view this content.

Open the VBA editor by hitting Alt F11.
Insert a new module with Insert - Module
Paste in the above function
Go back to the sheet by hitting Alt F11.

In a suitable cell in row 1, enter =RemoveIfCrossCancel(BH1)

Remember to save the workbook as a macro enabled workbook .xlsm