1 2 3 4 5 6 7 8 9 10 -1 -2 -3 -4 -5 -6 -7 -8 -9 -10 sort like this 1 -1 2 -2 3 -3 4 -4 5 -5
N NAVEEN Jul 2, 2008 #1 1 2 3 4 5 6 7 8 9 10 -1 -2 -3 -4 -5 -6 -7 -8 -9 -10 sort like this 1 -1 2 -2 3 -3 4 -4 5 -5
P Pete_UK Jul 2, 2008 #2 Here's one way - put this formula in B1: =IF(A1<0,ABS(A1)+0.1,A1) then copy down for as much data as you have in column A. Then highlight both columns, click on Data | Sort and choose column B as the sort column. After the sort you can delete column B. Hope this helps. Pete
Here's one way - put this formula in B1: =IF(A1<0,ABS(A1)+0.1,A1) then copy down for as much data as you have in column A. Then highlight both columns, click on Data | Sort and choose column B as the sort column. After the sort you can delete column B. Hope this helps. Pete
