+ Reply to Thread
Results 1 to 2 of 2

Reversing column values

  1. #1
    Registered User
    Join Date
    08-28-2012
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    11

    Reversing column values

    Dear all,
    I have a problem relating to copy paste. I want to change the order of values in a column and paste these in another column, for example I have values in a column as under
    1
    2
    3
    4
    5
    I want to copy paste these values in another column in this way

    5
    4
    3
    2
    1

    Please help me on this,
    thanks
    Javaid

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    845

    Re: Reversing column values

    You could simply sort the column in reverse order (largest to smallest).
    But I guess your date is more complex than consecutive numbers. Same trick with a helper column. Copy/paste your date somewhere. In the next column place a 1 in the cell and drag down so you have consecutive numbers 1, 2, 3.... Then sort both columns based on the helper column largest to smallest.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Reversing Column Removal at End of Sheet
    By Big.Moe in forum Excel General
    Replies: 5
    Last Post: 01-05-2020, 04:01 PM
  2. Formula in VBA code is reversing values. How is this even possible?
    By mshaneweaver in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-29-2015, 04:59 PM
  3. [SOLVED] Make a backward message by reversing the entire order of values in cell?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-16-2013, 11:11 PM
  4. reversing a column of names
    By conductorbob in forum Excel General
    Replies: 2
    Last Post: 11-15-2006, 07:34 AM
  5. Reversing Positive and Negative Values - Possible?
    By JennyW in forum Excel General
    Replies: 6
    Last Post: 10-03-2006, 05:43 PM
  6. Reversing the Order of Values in a List
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-28-2005, 11:26 AM
  7. [SOLVED] Reversing cell values
    By ac512 in forum Excel General
    Replies: 5
    Last Post: 04-13-2005, 08:06 PM

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