ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I reverse the order of a column of numbers . . . (https://www.excelbanter.com/excel-discussion-misc-queries/3875-how-can-i-reverse-order-column-numbers.html)

Wyoming Buckeye

How can I reverse the order of a column of numbers . . .
 
I want to turn a long column of numbers upsidedown so that the last entries
become the first vice versa.

FGM

-----Original Message-----
I want to turn a long column of numbers upsidedown so

that the last entries
become the first vice versa.
.

If they are consecutive order just select them and do data
sort select descending or ascending. If they are not in
consecutive order in the column next to it put consecutive
numbers (ex.1..99 ) and select both areas and data sort on
the column with the consecutive numbers.
A reply is always nice to know that it worked for you.



All times are GMT +1. The time now is 02:19 AM.

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