| 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 |
| 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 | |||
Threaded Mode
