Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do I sort a range, column or rows, in a simple reverse order? 212, 456,
125, 345, becomes 345, 125, 456, 212. |
#2
![]() |
|||
|
|||
![]()
raisin,
A simple way is to put ascending numbers in an extra column: Put 1 in the first, then fill down with the Fill Handle holding Ctrl. Now do a sort of the whole thing, descending, on that column. Be careful that all of your columns get sorted. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "sugarraisin" wrote in message ... How do I sort a range, column or rows, in a simple reverse order? 212, 456, 125, 345, becomes 345, 125, 456, 212. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
I typed a column in reverse order, how do I flip it (upside down). | Charts and Charting in Excel | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
how to paste the values in reverse order in workbook | Excel Discussion (Misc queries) | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |