# Thread: sort active list (2003)

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

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

3. ## 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.

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

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

7. ## 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. ## 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
•