HELP ! Can Excel automatically do "Grouping"?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raj_Fiji - 27 May 2008 00:44 GMT

I have excel data, which I want to group by a number of conditions. I know I
could do this automatically in Access, but is there a way to do this in Excel
?

Pivot Tables might do this, but the only problem I face is that I need the
grouped data with all headings populated, unlike how data is presented in
Pivot tables.

Eg. I want the data to be grouped by heading 2 then, heading 2, then heading
6 and the amounts from the gouping summed. Any help would be appreciated.

Reply to this Message

Pete_UK - 27 May 2008 01:34 GMT

I think you might want Data | Subtotals - have a look in Excel Help
for Subtotal, then Overview of subtotals in List, to see if this is
what you are after.

Hope this helps.

On May 27, 12:44 am, Raj_Fiji <Raj_F...@discussions.microsoft.com>
wrote:

> I have excel data, which I want to group by a number of conditions. I know I
> could do this automatically in Access, but is there a way to do this in Excel
[quoted text clipped - 6 lines]
> Eg. I want the data to be grouped by heading 2 then, heading 2, then heading
> 6 and the amounts from the gouping summed. Any help would be appreciated.

Reply to this Message