Sorting formula results not working in 97

I realize this should be a simple task, but I can't get it to work. In column 'K' I have lottery numbers from 1-40 in 40 rows and in column 'R' I have formulas with their results. I'd like to automatically sort the results in descending order into 2 new columns, one column for the sorted descending values, and the other column for the corresponding lottery numbers. All of this hopefully while keeping the original columns untouched. Is this possible in my very old version of Excel? Even trying to sort the formula column into itself, it won't sort. It just stays the same.
Thanks!

Thanks. I had a problem. I assume the two columns that I'm sorting have to be next to each other before the sort? Well, since the original columns I have are K and R, I decided to insert a copy of column K (numbers 1-40) at R and have the formula results at S. So starting with the adjacent columns R and S, and T and U being the target columns, I tried copying and pasting your first equation at T2, but for some reason it creates a long blank cell that usurps whatever was to the right of it. I have another column there with other formula results that it eliminated. I also tried copying and pasting your second equation at U2 and the same thing happens. I realize that the letters need to be changed, but I don't understand why it's taking over the other cells to the right. It seems to be merging all of the cells to the right.

Yes. Coming up thanks!

Here is a copy of the areas that I'm concerned about and the actual rows and columns. What's interesting is that sorting regular numbers works fine. It's the formula results that wouldn't work with a simple sort. Thanks!

I see you're in PA. It's getting late and I understand not working on this tonight. I'm about to hit the hay. No emergency. Whenever you can get to it. Thanks again!

Hmmm. I found out that it was the pasting of the formula that was causing the cell row domination, so I typed it all in manually and it didn't do that, so that problem is solved. But for some reason it isn't sorting again. I'm thinking there may be a glitch in my software and an incompatibility with the later versions you're using.

Just to let you know what I'm seeing... In T I have a descending list from 40-1 and the corresponding values of each of those numbers in U, but no sorting of the 40 numbers according to the descending values of U.

I switched the first equation to this and it sorted T properly. =LARGE($S$1:$S$40,ROW(A1))
Now I need to alter the other equation to associate the correct 1-40 numbers to T's descending values.

I got it now. I learned from FDibbins formulas what to shoot for, and the attached file is what I ended up with.


=LARGE($S$1:$S$40,ROW(A1))

=VLOOKUP(U1,$S$1:$T$40,2,FALSE)