How can I collapse Excel data into categories?

M

mschargerfan

I am trying to cllapse data into categories for a data project for class. I
do not know how to do it.
 
D

Dav

Unless you provide a bit more information you are unlikely to get a
answer! How is the data structured for example. Are the classes fixe
so everything has to be for example in one of 4 classes. Does it nee
to be split by anything else.

If the data is in a list try looking at pivot tables, or sumif
countif, sumproduct.

The more time you take to explain what you are requiring, the mor
chance someone will give you an answer that will work. On the forum i
is generally thought to be bad practice to include attachments, as the
may have viruses.

Regards

Da
 
D

Dave Peterson

Sort your data by the group and use data|subtotals. Then you can use the
outlining symbols to the left to show/hide the details.

You can also apply outlining symbols manually via data|group and outline
 
Top