greekblogosfaira
New Member
- Joined
- Aug 18, 2016
- Messages
- 1
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]
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]