SORRY !
That was Low to High.
This is for High to Low:

=Large(A$1:A$20,ROWS($1:1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Suzuki" <Suzuki @discussions.microsoft.com wrote in message
...
I would like to use a formula to copy all the values from a range (in a
column) to the next column, at which time they are sorted from high to
low.
This way I can see the originial data side by side with the sorted data.