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
|