You can configure the formula to reference a pre-determined range, so that
you could use the rest of the row for your other data.

For example, say your original numbers were only occupying, say 15 columns,
from V9 to AJ9.

You could then enter this formula *anywhere*:

=LARGE($V$9:$AJ$9,COLUMNS($A$1:A1))

Even in say B9, and copy it across to P9.


--
HTH,

RD

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

"Niniel" wrote in message
...
Very cool!

I had to tinker with it a bit since I had other date in the same row that
I
didn't want sorted, but I just moved my target data to an otherwise empty
row, so now it's working like a charm.

Thanks a lot!