Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |