Hi Everyone,

I have a problem and even after trying out several things I am not
able to solve it. I have a table as below:

Code Book Amount
9885F3 ABC 10
9885F3 ABC -10
9885F3 ABC 10
9885F3 PQR -10
7864D1 XYZ 100
7864D1 XYZ -100
465D45 BOMS 50
465D45 BOMS -50
465D45 BOMS 50
465D45 BOMS -50
465D45 BOMS 50

I need to flag the items that belong to the same code and same book
and have equal and opposite amounts. In the above case, it should flag
item # 1, 2 and should not fall the # 3 and 4. Likewise it should flag
# 5, and #6 and then it should flag the next four items and leave the
last one. Any help on this will be much appreciated.

Regards,
-AG