MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Reverse a column of data

Posted by Brian on January 28, 2002 6:28 AM

I have a long column of numbers. I want to reverse the list so the bottom number (cell A10000)comes to the top(cell A1)and the list is then upside down.
The list is not in numerical order and must stay in exactly the same sequence in reverse.
Can anyone help please?

Posted by Ivan F Moala on January 28, 2002 7:10 AM

In cell B1 enter 1
In cell B2 enter 2
Select B1:B2
Move cursor to Bottom right of range
you should get a + sign
Double click this cell handle
You should get a seq of numbers all the way
down as far as you data in column A.
Now select A1:B1
Press the End key then
Hold shift and press the Down arrow this will
select All your data in columns A:B

Now sought on column B