Remove Duplicate with Debit & Credit

**Sniper** · 11-24-2011, 10:20 AM

Good Afternoon

I have excel sheet with transaction data, I am trying to get a code to remove Duplicate date where there is a credit and a debit with the same Client no in a range. I have attached a example of what I am trying to do.

Thanks

**antoka05** · 11-24-2011, 10:58 AM

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

**Sniper** · 11-24-2011, 11:02 AM

Thanks antoka05 exactly what i needed it to do. Excel - lent

**Sniper** · 11-25-2011, 09:20 AM

Afternoon

This Code runs perfect, but I found another problem. If there's more than 2 transactions for the same account number it doesn't balance. I tried to play with the code but still nothing.

I have attached an example.

Thanks