software

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:

ItemDate
ah1/5/2005
aa1/12/2005
ab1/12/2005
ac1/27/2005
ad1/27/2005
ae1/27/2005
af1/28/2005
ag2/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.

ah1/5/2005
aa1/12/2005
ac1/27/2005
af1/28/2005
ag2/1/2005

Grouping Manually becomes a pain after about the 1st hundred or so groupings.

ThanksHave you tried doing a quot;sortquot; ?

quot;jibaquot; wrote:

gt; I receive lists of a large number of rows. I would like to have Excel
gt; automatically group based on an item that is the same. For example:
gt;
gt; ItemDate
gt; ah1/5/2005
gt; aa1/12/2005
gt; ab1/12/2005
gt; ac1/27/2005
gt; ad1/27/2005
gt; ae1/27/2005
gt; af1/28/2005
gt; ag2/1/2005
gt;
gt; Is there a way for Excel to automatically group the items so that if you
gt; click on you can see all items with the same date.
gt;
gt; ah1/5/2005
gt; aa1/12/2005
gt; ac1/27/2005
gt; af1/28/2005
gt; ag2/1/2005
gt;
gt; Grouping Manually becomes a pain after about the 1st hundred or so groupings.
gt;
gt; Thanks
gt;

You can use the Datagt;Subtotals command, to subtotal at each change in date.

jiba wrote:
gt; I receive lists of a large number of rows. I would like to have Excel
gt; automatically group based on an item that is the same. For example:
gt;
gt; ItemDate
gt; ah1/5/2005
gt; aa1/12/2005
gt; ab1/12/2005
gt; ac1/27/2005
gt; ad1/27/2005
gt; ae1/27/2005
gt; af1/28/2005
gt; ag2/1/2005
gt;
gt; Is there a way for Excel to automatically group the items so that if you
gt; click on you can see all items with the same date.
gt;
gt; ah1/5/2005
gt; aa1/12/2005
gt; ac1/27/2005
gt; af1/28/2005
gt; ag2/1/2005
gt;
gt; Grouping Manually becomes a pain after about the 1st hundred or so groupings.
gt;
gt; Thanks
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThanks the Datagt;Subtotals worked. I tried using sort but that doesn't
actually group the dates like the Datagt;Subtotals. Thanks again!

quot;Debra Dalgleishquot; wrote:

gt; You can use the Datagt;Subtotals command, to subtotal at each change in date.
gt;
gt; jiba wrote:
gt; gt; I receive lists of a large number of rows. I would like to have Excel
gt; gt; automatically group based on an item that is the same. For example:
gt; gt;
gt; gt; ItemDate
gt; gt; ah1/5/2005
gt; gt; aa1/12/2005
gt; gt; ab1/12/2005
gt; gt; ac1/27/2005
gt; gt; ad1/27/2005
gt; gt; ae1/27/2005
gt; gt; af1/28/2005
gt; gt; ag2/1/2005
gt; gt;
gt; gt; Is there a way for Excel to automatically group the items so that if you
gt; gt; click on you can see all items with the same date.
gt; gt;
gt; gt; ah1/5/2005
gt; gt; aa1/12/2005
gt; gt; ac1/27/2005
gt; gt; af1/28/2005
gt; gt; ag2/1/2005
gt; gt;
gt; gt; Grouping Manually becomes a pain after about the 1st hundred or so groupings.
gt; gt;
gt; gt; Thanks
gt; gt;
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;