Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    sort active list (2003)

    I have a worksheet in which I generate daily values for several years in column J . Is there a way to take the daily values from column J and have them copied in descending order to another column; e.g., ("K"). Right now, every time a variable changes and the daily values change I have to do a copy/paste special/values and then sort/descending column K.

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: sort active list (2003)

    Why is the step of pasting values to column K necessary? Can't you sort on column J?

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: sort active list (2003)

    The numbers are used for different graphs. The column j data is by date from 2/72 to 12/31/07 and is used elsewhere (along with other data) for graphing with date as the x-axis. The column k data is sorted descending to use as part of a frequency distribution graph. On the attached workbook, I've done a paste/values and truncated the files to reduce size, but it should give you an idea of what's happening.

    I hope this helps.

    thanks.
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: sort active list (2003)

    You could enter the following formula in K3:
    <code>
    =LARGE($J$3:$J$6000,ROW()-2)
    </code>
    adjusting the range J3:J6000 as needed, and fill down as far as needed. This will result in a list of values from column J sorted in descending order. If you have a large worksheet with many formulas, it might be slow, though.

  5. #5
    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: sort active list (2003)

    In K3 you could enter something like:
    =LARGE($J$3:$J$18,ROW()-2)

    and copy it down the row. Expand the range as desired. If you start in another row other than 3 change the "-2" accordingly to 1 less than the starting row number.

    Steve

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: sort active list (2003)

    Great minds... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  7. #7
    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: sort active list (2003)

    How true... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    And they not only think alike, but seem to do it at the same time....

    Steve

  8. #8
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: sort active list (2003)

    and they're right, too!
    worked.
    thanks.

Posting Permissions

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