I think I have a problem that hasn't been discussed in any forums I've searched.

I need to delete rows where all criteria are the same except the fees column are offsetting values; sum of 0. Example:

Acct No. Name Date Provider Fees
001 Dave 1/1/08 Fred 500
001 Dave 1/1/08 Fred -500
001 Dave 1/1/08 Fred 500
002 Jeff 1/1/08 Fred 500
003 Fran 1/7/08 Eric -250

Either rows 1 and 2, or rows 2 and 3, need to be deleted. The negative value in this example is due to an erroneous charge being negated. Once the offsetting rows are deleted all negative values in the fees columns will need to be deleted, row 5. There are about 10,000 rows of data.
After reading other posts it appears that the best approach is to start is at the last row and compare it to all of the data above it but I am at a loss as to how do do this. Any and all help is greatly appreciated.