I want to sort negative and positive numbers so that they align together row by row eg 1

-1

2

-2

You can do it with a helper column. With your data in column A:

A 1) 1 2) -4 3) 3 4) -2 5) -1 6) -3 7) 4 8) 2First sort column A as you would normally, smallest to largest.

Then, put this formula in Cell B1 and drag down: =ABS(A1)

Next select both columns A & B, but sort on column B

You should end up with:

A B 1) -1 1.00 2) 1 1.00 3) -2 2.00 4) 2 2.00 5) -3 3.00 6) 3 3.00 7) -4 4.00 8) 4 4.00Delete column B

See how that works.

MIKE

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History