how do i sort a set of averages and have them list in descending o

[Guest]

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

 

[Richard Buttrey]

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 Data>Sort, click the descending option for the
Average column and then "OK"

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

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?

 

[Ragdyer]

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.

 

[Guest]

Yes, In The Average Column is, of course, =Avg(b33). All the avg column
has the =AVG formula.
And the data column is strictly text.

 

[Ragdyer]

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.

 

[Guest]

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

 

[Ragdyer]

Thanks for the feed-back.