9.14 Delete data that can be paired

 

Here below is a data table:

imagepng

Delete the rows that have the same data in the fields of ID, Name and Item, and whose positive and negative values in Value field can be completely offset.

=spl("=E(?1).group(ID,Name,Item).select(~.sum(Value)!=0).conj()",A1:D10)

imagepng