sort below data
 

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

sort below data
 

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

On Jul 2, 10:45*am, NAVEEN wrote:
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