Remove Opposite Values

[greekblogosfaira]

I have the following data and I would like to remove opposite values "rows".

For example using the following data, rows 1 and 2 should be removed since they have the same description and exactly the same but opposite values.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Num[/TD]
[TD]Reference[/TD]
[TD]Description[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]Test[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]Test[/TD]
[TD]-50[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD]Test[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4[/TD]
[TD]Test[/TD]
[TD]50[/TD]
[/TR]
</tbody>[/TABLE]

 

[igold]

Hi,

In your sample data and stated criteria, rows 2 & 3 could be removed instead of rows 1 & 2. Could you provide a better explanation of what your requirements are.

igold