Thanks, I changed the relative to absolutes and it works great!

"Ragdyer" wrote:

Your formulas are changing their cell references as they change location
with the sort since they are relative

Either revise your formulas from relative to absolute:

=AVERAGE($B$3:$P$3)

Or copy your columns and then "Paste Special", "Values", to remove the
formulas, leaving the data behind, so that it can be sorted.

As a habit, I *manually* select the *entire* range that's to be sorted.
Never trust XL to choose the range for you.
It's right most of the time, but *not* all of the time.
--
HTH,

RD

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

..

"ucastores" wrote in message
...
Yes, In The Average Column is, of course, =Avg(b3:p3). All the avg column
has the =AVG formula.
And the data column is strictly text.

"Ragdyer" wrote:

I'll bet you have formulas in those columns, not just keyed in data.

Post an example of the formulas you're using.

If both columns contain formulas, give an example of each.
--
Regards,

RD


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

--------------------------------------------------------------------------
-
"ucastores" wrote in message
...
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
__________________________