Say that your original numbers are in Row 1.

Enter this formula *anywhere* (except Row 1), and drag across to copy as
needed:

=LARGE(1:1,COLUMNS($A$1:A1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Niniel" wrote in message
...
Cool, that wasn't all that difficult.

Just out of curisosity - can this be programmed as well? So that when my
input cells get populated, I can pick up the re-arranged numbers in
another
row without having to do anything else?