Forum Discussion
How to remove two rows based on their specific values i.e. remove a payment that later gets refunded
Hi JollyRoger01 ,
I created this sample data.
The result is this.
The method is to first find out the number with Refund, and then add a custom number to turn the found out number into the opposite. Then add the opposite sequence as a new query.
Turn the list into a table. Then use merge to merge the two tables, filter and delete redundant columns.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JollyRoger01 ,
I created this sample data.
The result is this.
The method is to first find out the number with Refund, and then add a custom number to turn the found out number into the opposite. Then add the opposite sequence as a new query.
Turn the list into a table. Then use merge to merge the two tables, filter and delete redundant columns.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That's perfect, thanks so much for your help on this!
This makes my transaction records more accurate as I'm not recording credits and debits that didn't really occur.