This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've got tens of thousands of rows of transaction data, and due to the accounting system it comes from, there are pairs of data I need to remove. However, I'm struggling to specify that pairs of rowsshould only be deleted where one of them are negative.
I've tried the unique tool, but in some cases, there are 4 entries of $10 and 1 entry of -$10. Only 1 of the positive and 1 of the negative should be deleted. You can see an example below:
P.S. I just noticed there's a table tool I could have used. Hopefully my formatting works. X_X
E.g. scenario - want to remove the red expense code amount absolute value key (category + abs + account code) count of absolute value 12345-67 10 10 Meal1091110-67 5