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

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

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 right
corner of the selection, drag to B10


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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=396301

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 DataSort Select you helper column, xlAscending and no
header row. Click sort. Done. Get rid of the helper column/numbers.

Roy
--
(delete .nospam)




"vpedchenko" wrote:

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

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

"vpedchenko" wrote:

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

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

Many thanks to everybody for your help!


"vpedchenko" wrote:

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