Hi Folks,
I have databaset where Policy numbers and net amount in the sheet. How to extract those polcies where sum of net is 0 but Same policy can have multiple rows with Net amount and it could be cross match. for example below policy has 3 rows where 2nd and 3rd sum is 0. So I need that rows. it can match 1st and 3rd row as well.
Poliyc Net
A 299
A 99
A -99