View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dolphinv4 Dolphinv4 is offline
external usenet poster
 
Posts: 27
Default 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