Removing Row

[Simon1187]

Hi there, 

I am trying to remove the return money and paid money in from payment from the same customer Id. Could you please help me with how can I remove them? Sample data is below: 

Thanks,

[atcodedog05 · Accepted solution]

Hi @Simon1187 

Here is how you can do it.

Workflow:

Removing rows where paid is opposite and customer id is same.

Hope this helps : )

[Simon1187 · Accepted solution]

Hi @atcodedog05 

Thanks, 

[atcodedog05]

Happy to help : ) @Simon1187 

Cheers and have a nice day!