Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    Texas, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reversing order of entries in a column (OXP-SP2 on WinME)

    This has probably been asked before, but the search feature is down and I have a need-to-know problem.

    I need to add a series of results to a worksheet from an outside spreadsheet on a network that contains data in descending order of date occurrence. I do not have update privileges for that file. My worksheet is in ascending date sequence, but it has links to others of my worksheets; so sorting it to match the sequence of the outside data screws up the links. I can copy and paste the results from the network spreadsheet but need to associate values with the date on which they occurred; sorting them is NOT the issue. I have a decade of bi-weekly values to bring in.

    Does Excel allow one to simply reverse the entries in a single column range of rows? I am not macro or VBA literate.

    All suggestions greatly appreciated and gratefully received.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Reversing order of entries in a column (OXP-SP2 on WinME)

    I am not sure exactly what you need and all the issues.

    VLOOKUP will work on ascending or if descending you can look for exact match, or MATCH will work with ascending or descending rows (or exact match). This should allow "looking up" any of the information from the other workbook. Just treat it like an external data set in the VLOOKUP, or INDEX/MATCH combo.

    To sort just one Column (as you asked) is simply done by highlighting the column of interest Or a range, selecting Data - sort, check "continue with current selection" and then click on ascending or descending.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    Texas, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Call me Roseanne Rosanna Dana

    My forehead is still stinging from the slap I gave it!

    To solve my problem, I copied and pasted the data series. I then auto-numbered the column beside it then selected both columns and sorted in descending sequence on the auto-numbered column. Doh!!!

    Sorry for wasting the bandwidth with my mental block. I posted my solution rather than deleting the question just in case there's someone else like me out there.

    Is there a better way to skin this cat?

Posting Permissions

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