I'm trying to delete contracts that reconcile (sum to 0). in column A i have the contract number and in column B i have the amounts (see example attached).

I need to create a loop that 1) Identify first contract number (contract number 1 in my example) 2) sum column B for all with the same contract number of 1 (I was planning on using a sumif) 3) assign sum to variable (lets call it "test") 4) delete all rows with the same contract number (column A) if "test" equals 0. The loop needs to continue through each unique contract number in column A (i.e. 1,2, and 3).

The main problem I have is starting, how do I tell the loop to identify and use unique contract numbers.

Example.xlsx