how do i sort a set of averages and have them list in descending o
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
__________________________
|