How can I collapse Excel data into categories?
 

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

How can I collapse Excel data into categories?
 

Unless you provide a bit more information you are unlikely to get an
answer! How is the data structured for example. Are the classes fixed
so everything has to be for example in one of 4 classes. Does it need
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 more
chance someone will give you an answer that will work. On the forum it
is generally thought to be bad practice to include attachments, as they
may have viruses.

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=540536

How can I collapse Excel data into categories?
 

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

mschargerfan wrote:

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

--

Dave Peterson