How do I get Excel to automatically group items?

[Guest]

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

 

[Guest]

Have you tried doing a "sort" ?

 

[Debra Dalgleish]

You can use the Data>Subtotals command, to subtotal at each change in date.

 

[Guest]

Thanks the Data>Subtotals worked. I tried using sort but that doesn't
actually group the dates like the Data>Subtotals. Thanks again!