Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grouping
this is about basic grouping. i have four columns four each week of a month.
i want to group them so that i can open it up for the month when needed. tried selecting columns and going to DRAW but the GROUPING tab is not highlighted |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grouping
DataGroup and outline
-- Kind regards, Niek Otten Microsoft MVP - Excel "conor wardie" wrote in message ... | this is about basic grouping. i have four columns four each week of a month. | i want to group them so that i can open it up for the month when needed. | tried selecting columns and going to DRAW but the GROUPING tab is not | highlighted |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grouping
perfect, thanks.
"Niek Otten" wrote: DataGroup and outline -- Kind regards, Niek Otten Microsoft MVP - Excel "conor wardie" wrote in message ... | this is about basic grouping. i have four columns four each week of a month. | i want to group them so that i can open it up for the month when needed. | tried selecting columns and going to DRAW but the GROUPING tab is not | highlighted |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grouping
Hi Niek - I have a follow-up grouping question. My data is in date format mm/dd/yyyy and I want to group by week. I have the analysis pak and my formula is WEEKNUM(C3) Q: How do I display the Monday-date of that week in the pivot table chart? My chart has the x-axis as 1,2,3,4....25,26....36 (this week) (manager says "I don't want to know it is week 26, give me a date!!) Thanks for your reply & assistance. Jimbo213 "Niek Otten" wrote: DataGroup and outline -- Kind regards, Niek Otten Microsoft MVP - Excel "conor wardie" wrote in message ... | this is about basic grouping. i have four columns four each week of a month. | i want to group them so that i can open it up for the month when needed. | tried selecting columns and going to DRAW but the GROUPING tab is not | highlighted |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
outlining / Grouping | Excel Discussion (Misc queries) | |||
excel should allow me Indian number grouping ##,##,##,###.## | Excel Worksheet Functions | |||
How do I get the grouping dialogue box to appear in Pivot Tables? | Excel Worksheet Functions | |||
Protected cells and grouping | Excel Discussion (Misc queries) | |||
Grouping | Excel Discussion (Misc queries) |