Deleting rows that are equal amts but different signs
Hi,
i have a long list of data where there a SOME rows with equal amounts but
with opposite signs, ie, row 3 may have amount 1234 and row 14 is -1234. I
want to have these equal but opposite amounts deleted from my list. The rows
may or may not have same invoice number, ie, row 3 may have invoice number
321 but row 14 may have invoice number 321A (or 03210 etc).
What is the fastest way to do this?
Thanks,
Dolphin
|