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