Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to automatically group items?
I receive lists of a large number of rows. I would like to have Excel
automatically group based on an item that is the same. For example: Item Date ah 1/5/2005 aa 1/12/2005 ab 1/12/2005 ac 1/27/2005 ad 1/27/2005 ae 1/27/2005 af 1/28/2005 ag 2/1/2005 Is there a way for Excel to automatically group the items so that if you click on you can see all items with the same date. ah 1/5/2005 + aa 1/12/2005 + ac 1/27/2005 af 1/28/2005 ag 2/1/2005 Grouping Manually becomes a pain after about the 1st hundred or so groupings. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to automatically group items?
Have you tried doing a "sort" ?
"jiba" wrote: I receive lists of a large number of rows. I would like to have Excel automatically group based on an item that is the same. For example: Item Date ah 1/5/2005 aa 1/12/2005 ab 1/12/2005 ac 1/27/2005 ad 1/27/2005 ae 1/27/2005 af 1/28/2005 ag 2/1/2005 Is there a way for Excel to automatically group the items so that if you click on you can see all items with the same date. ah 1/5/2005 + aa 1/12/2005 + ac 1/27/2005 af 1/28/2005 ag 2/1/2005 Grouping Manually becomes a pain after about the 1st hundred or so groupings. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to automatically group items?
You can use the DataSubtotals command, to subtotal at each change in date.
jiba wrote: I receive lists of a large number of rows. I would like to have Excel automatically group based on an item that is the same. For example: Item Date ah 1/5/2005 aa 1/12/2005 ab 1/12/2005 ac 1/27/2005 ad 1/27/2005 ae 1/27/2005 af 1/28/2005 ag 2/1/2005 Is there a way for Excel to automatically group the items so that if you click on you can see all items with the same date. ah 1/5/2005 + aa 1/12/2005 + ac 1/27/2005 af 1/28/2005 ag 2/1/2005 Grouping Manually becomes a pain after about the 1st hundred or so groupings. Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to automatically group items?
Thanks the DataSubtotals worked. I tried using sort but that doesn't
actually group the dates like the DataSubtotals. Thanks again! "Debra Dalgleish" wrote: You can use the DataSubtotals command, to subtotal at each change in date. jiba wrote: I receive lists of a large number of rows. I would like to have Excel automatically group based on an item that is the same. For example: Item Date ah 1/5/2005 aa 1/12/2005 ab 1/12/2005 ac 1/27/2005 ad 1/27/2005 ae 1/27/2005 af 1/28/2005 ag 2/1/2005 Is there a way for Excel to automatically group the items so that if you click on you can see all items with the same date. ah 1/5/2005 + aa 1/12/2005 + ac 1/27/2005 af 1/28/2005 ag 2/1/2005 Grouping Manually becomes a pain after about the 1st hundred or so groupings. Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file automatically opens - More Info | Excel Discussion (Misc queries) | |||
How do I automatically open linked documents in Excel? | New Users to Excel | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Can't group by dates in Excel 2003 pivot table | Excel Discussion (Misc queries) | |||
how do I alphabetize items automatically in excel | Excel Worksheet Functions |