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