ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sort in reverse order (https://www.excelbanter.com/excel-discussion-misc-queries/3022-sort-reverse-order.html)

sugarraisin

sort in reverse order
 
How do I sort a range, column or rows, in a simple reverse order? 212, 456,
125, 345, becomes 345, 125, 456, 212.

Earl Kiosterud

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.





All times are GMT +1. The time now is 05:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com