selecting all Amount netting to zero

[joshikalyani]

I attached the data, where i'm trying to get the all amounts which are netting to zero

amounts can not be in sequence

eg, netting amount can not be from consecutive rows

[gautiergodard]

Hey @joshikalyani 

You could do something like this!

**Please like and mark this thread as resolved if this provided the answer to your problem**

[joshikalyani]

For the netting zero solution , it is working on consecutive rows only , I've attached excel where it is taking first 2 netting records but not other two.

Highlighted in green 4 records

[gautiergodard]

@joshikalyani the difficulty here is there doesn't seem to be any pattern or way to group/sort your data set to apply a consistent logic. Attached is an option for sorting in a consistent manner based on whether the absolute value of a number and whether it's positive or negative.

[joshikalyani]

Thanks, but it still missing other 2 matches