Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to turn a long column of numbers upsidedown so that the last entries
become the first vice versa. |
#2
![]() |
|||
|
|||
![]()
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. |
#3
![]() |
|||
|
|||
![]()
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
How can I reverse the order of a column of numbers . . . | Excel Discussion (Misc queries) | |||
sort in reverse order | Excel Discussion (Misc queries) | |||
I typed a column in reverse order, how do I flip it (upside down). | Charts and Charting in Excel | |||
how to paste the values in reverse order in workbook | Excel Discussion (Misc queries) |