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/3876-how-can-i-reverse-order-column-numbers.html)

buckeye999

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.

tjtjjtjt

You could do this with a helper column.
In a blank column next to the column you want to reverse:
Type 1 in the first cell, 2 in the second cell.
Then, select both cells and double-click on the Fill Handle to fill a series
of increasing numbers. Then, Sort Desceding by the new column.
When you are done, you can delete the helper column.

tj

"buckeye999" wrote:

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


Jason Morin

Say your list was in A1:A10. In B1 put this and fill down:

=OFFSET($A$1,COUNTA($A$1:$A$10)-COUNTA($A$1:A1),)

or

=OFFSET($A$1,COUNTA($A$1:$A$10)-ROW(),)

HTH
Jason
Atlanta, GA

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

that the last entries
become the first vice versa.
.



All times are GMT +1. The time now is 06:41 PM.

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