If anyone could help me with this I would be extremely grateful. I am currently putting a few filters in place to flag debits with corresponding credits (example below) and then going through and manual deleting. This can be very time consuming when I am sometimes dealing with spreadsheets with 100k+ rows. I have searched for a solution on the web and thought I had a formula that would work, but can’t seem to apply this correctly to my situation.
Please let me know if you need any additional info and thanks in advance for taking a look.
Example of formula that I assumed would work to automate reversal flagging: =AND(COUNTIF($B$2:$B$984,B2),COUNTIF($A$2:$A$984,A2),COUNTIF($C$2:$C$984,ABS(C2)>0))
Eample of spreadsheet:
|Service Date||Inventory ID||Qty||Supply|
By: Nathan Meadows