Invert columns

[gshock]

I'm looking for a simple way to take a column of data and restack it in reverse order. The data isn't necessarily in alphabetical or numerical order, i.e. 2, 5, 7, 3, 4, 9, etc. The sequence is important. If this data is in a column, I want to restack in reverse order, namely, 9, 4, 3, 7, 5, 2.

Thanks for the help.

(Love this forum.) I look so cool because of all your help.

[Richard Schollar]

Hi

Assuming data in A1:A100:

=INDEX($A$1:$A$100,ROWS($A$1:$A$100)-ROWS($A$1:$A1)+1)

in column B1 copied down to B100.

Richard

[Ron Coderre]

With
A1:A6 containing your list: 2,5,7,3,4,9

If you want to actually reorder A1:A6,
Maybe this?....
B1: =ROW()
Copy B1 down through B6.

Now you have your list in Col_A
and an ascending series of numbers in Col_B

Select A1:B6

From the Excel Main Menu:
<data><sort>
Sort by: Column_B: Descending.

Col_A will be listed in reverse order: 9,4,3,7,5,2
Is that something you can work with?

[gshock]

Thanks for the tips. The formula works great in a group of cells. But I'm trying to incorporate it into my macro. It's part of a data cleanup for some other (much bigger) spreadsheets. The more automation, the better. I posted a new question here: http://www.excelforum.com/showthread...58#post1950458

Thanks for the help. Much appreciated.

Regards,
-gshock