View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JHL JHL is offline
external usenet poster
 
Posts: 6
Default Extract select group of numbers

I have a large column of numbers containing both positive and negative
amounts. I created the absolute value of these numbers in a separate column.
Sorting the absolute value indicates I have offsetting amounts in the
original number column.How can I extract only those values that are not
offset? For example,

Amt = 1,000.00

Offset = -1,000.00

Also, some of the amounts have multiples of the same number. For example
after sorting I'll have:

15,000.00

15,000.00

15,000.00

..

..

..

15,000.00

-15,000.00

-15,000.00

-15,000.00

..

..

..

-15,000.00

525.00

475.00

125,000.00

450,000.00

100.00

75.00

..

..

..

Thanks for your help.

JHL