HELP ! Can Excel automatically do "Grouping"?
 

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.

HELP ! Can Excel automatically do "Grouping"?
 

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
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
?

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.