| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sort a set of averages and have them list in descending o
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 __________________________ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sort a set of averages and have them list in descendi
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 __________________________ |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sort a set of averages and have them list in descendi
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 __________________________ |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sort a set of averages and have them list in descendi
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 __________________________ |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sort a set of averages and have them list in descendi
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 __________________________ |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sort a set of averages and have them list in descendi
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 __________________________ |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sort a set of averages and have them list in descendi
Thanks for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ucastores" wrote in message ... 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 __________________________ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
