Been There, Done That. All it did was sort the data, not the numbers.
Tried it twice, the first time where i had placed it before your posting (and
tried it before, too), then after i moved it so nothing else was around it
and it did the same. Any other suggestions?

"Richard Buttrey" wrote:

On Sat, 2 Sep 2006 14:01:01 -0700, ucastores
wrote:

I have a column entitled 'months' and one 'avg' and i am trying to rearrange
them so that the appropriate month and it's average is listed in from highest
to lowest in a another set of columns. Can Anyone help me?
excel 2002

If you really want them sorted in another set of columns then you'll
first need to copy and paste them to the new position.

Make sure the two columns are next to each other, and not next to
another set of data, then with the active cell anywhere in the range
to be sorted, choose DataSort, click the descending option for the
Average column and then "OK"

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________