+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    vpedchenko
    Guest

    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. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    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


    Quote 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. #3
    Roy Wagner
    Guest

    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. #4
    Rowan
    Guest

    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. #5
    David McRitchie
    Guest

    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" <[email protected]> wrote in message news:[email protected]...
    > Ie, if i have a set of 10 numbers in column A, how to copy the into column B
    > in reverse order?




  6. #6
    vpedchenko
    Guest

    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?


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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