Hi Everyone,

I've got a large workbook, approximately 700k entries, where I need to find entries that don't have a canceling values. Here's an example:

5,000
5,000
-5,000
-5,000
1,000
-1,000
1,000

In this case, one of the 1,000's would be left and the other rows deleted. There's also extra information in other columns if that makes a difference. The fact that one of the 1,000's is the wrong one to delete doesn't bother me as I'll at least know the dollar amount of a problem entry.

I found a reference to this idea he
http://www.excel-answers.com/microso...ng-values.aspx

Unfortunately the macro wasn't working for me and I was unsuccessful at debuging it.

Thanks all for your help!

BK