| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas to Group Data By Date
I have a list of items that occured on a daily basis since January-09, is
there any formula that will show what 2 week period the item falls in?-- CK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas to Group Data By Date
I would think Pivot table may be better...
Drop the dates and your other desired field into the rows columns. Right-click on a date, select outline and grouping, group. Pick weeks and enjoy! "ColleenK" wrote: I have a list of items that occured on a daily basis since January-09, is there any formula that will show what 2 week period the item falls in?-- CK |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas to Group Data By Date
My preference would be to use a pivot table, but the dates come across as
every day. Is there a way in pivot tables to group the dates? -- CK "Sean Timmons" wrote: I would think Pivot table may be better... Drop the dates and your other desired field into the rows columns. Right-click on a date, select outline and grouping, group. Pick weeks and enjoy! "ColleenK" wrote: I have a list of items that occured on a daily basis since January-09, is there any formula that will show what 2 week period the item falls in?-- CK |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas to Group Data By Date
That would be where you right-click on any date and select Group and show
detail, then Group. Should give you the option to group by days, weeks, months, etc. And you can select your desired range of dates. "ColleenK" wrote: My preference would be to use a pivot table, but the dates come across as every day. Is there a way in pivot tables to group the dates? -- CK "Sean Timmons" wrote: I would think Pivot table may be better... Drop the dates and your other desired field into the rows columns. Right-click on a date, select outline and grouping, group. Pick weeks and enjoy! "ColleenK" wrote: I have a list of items that occured on a daily basis since January-09, is there any formula that will show what 2 week period the item falls in?-- CK |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas to Group Data By Date
Thank you so much, it did not dawn on me to use groups in Pivot tables
-- CK "Sean Timmons" wrote: That would be where you right-click on any date and select Group and show detail, then Group. Should give you the option to group by days, weeks, months, etc. And you can select your desired range of dates. "ColleenK" wrote: My preference would be to use a pivot table, but the dates come across as every day. Is there a way in pivot tables to group the dates? -- CK "Sean Timmons" wrote: I would think Pivot table may be better... Drop the dates and your other desired field into the rows columns. Right-click on a date, select outline and grouping, group. Pick weeks and enjoy! "ColleenK" wrote: I have a list of items that occured on a daily basis since January-09, is there any formula that will show what 2 week period the item falls in?-- CK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Group under Data Group and Outline Data not working. Help. | Excel Worksheet Functions | |||
| Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
| "Data Group and Outline Group" feature Limited to 8 levels | Excel Discussion (Misc queries) | |||
| sum the results of a group of formulas | Excel Worksheet Functions | |||
| Lookup Oldest date from previously selected Group Data | Excel Worksheet Functions | |||
Linear Mode
