How to reverse the order of data in a single column in Excell?

[Guest]

Ie, if i have a set of 10 numbers in column A, how to copy the into column B
in reverse order?

 

[Bryan Hessey]

In B1 put

=INDIRECT("A"&11-ROW())

and formula-drag that to B10

To formula-drag, select B1 and click on the small + in the bottom righ
corner of the selection, drag to B10

 

[Guest]

Pick or add an empty column to use as a helper column. Using the same rows as
your data to be sorted, number them from 10 to 1.

Select the data to be sorted including your helper column. Be careful about
other data on the sheet. If you have data in other columns, it all needs to
be sorted together to keep your data intact.

On the menus select >Data>Sort> Select you helper column, xlAscending and no
header row. Click sort. Done. Get rid of the helper column/numbers.

Roy

 

[Guest]

One Way:

If the numbers are in the range A1:A10 then in B1 place the formula:

=INDEX($A$1:$A$10,-ROW(A1)+ROW($A$1)+COUNTA($A$1:$A$10),1)

and copy down to B10.

Hope this helps
Rowan

 

[David McRitchie]

If you want to make the changes in place with a macro, you would have to
select the cells you want to reverse vertically in a column then run
http://www.mvps.org/dmcritchie/excel/join.htm#reversi

 

[Guest]

Many thanks to everybody for your help!