how do I sort in excel with positive and nega

April 11, 2011 at 18:42:58
Specs: Windows 7
I want to sort negative and positive numbers so that they align together row by row

eg 1
-1
2
-2


See More: how do I sort in excel with positive and nega

Report •

#1
April 11, 2011 at 19:26:32
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)  2

First 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.00

Delete column B

See how that works.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question