help removing inventory entry reversals from single column

Hello,

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.

-Nathan

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
5/15/2014 60505082901 16 30
5/21/2014 00115146845 30 7
6/15/2014 60505082901 16 30
5/29/2014 00173068220 18 17
3/6/2014 53746027205 14 7
3/6/2014 00093314705 28 7
4/28/2014 00173068220 18 16
2/20/2014 52544038328 28 28
4/2/2014 52544038328 -28 -28
4/2/2014 52544038328 28 28
4/30/2014 52544038328 -28 -28
4/30/2014 52544038328 28 28

By: Nathan Meadows

Leave a Reply

Your email address will not be published. Required fields are marked *