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

1. ## 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?

2. 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

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

3. ## RE: How to reverse the order of data in a single column in Excell?

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
--
(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?

4. ## RE: How to reverse the order of data in a single column in Excell?

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?

5. ## Re: How to reverse the order of data in a single column in Excell?

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" <vpedchenko@discussions.microsoft.com> wrote in message news:F2FD80D3-002D-46A6-9CBF-8A2FAB57D3A1@microsoft.com...
> Ie, if i have a set of 10 numbers in column A, how to copy the into column B
> in reverse order?

6. ## RE: How to reverse the order of data in a single column in Excell?

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?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1