Matching positive and negative numbers

UPDATE: We have a complete answer with screenshots on theĀ Match positive and negative numbers in excel post.

A visitor wrote (translated)

I want to find out how I can sort data in Excel so that the positive and negative numbers are next to each other that generates a net value of zero e.g.

+800000

-800000

+10000

-10000

Thanks

Not an exact science but what you can do is create a new column and use the ABS function to remove the sign. Then sort on this new column so that in the new column the, for example, 800000’s will be next to each other but in the old column it will show the positive and negatives under each other. Unlikely to be exact though.