Re: How can I collapse Excel data into categories?
- From: Dav <Dav.27kzwy_1147247100.9395@xxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 10 May 2006 02:41:06 -0500
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?action=getinfo&userid=27107
View this thread: http://www.excelforum.com/showthread.php?threadid=540536
.
- Prev by Date: Re: Divide by 3
- Next by Date: Re: making a cell zero out after calculation
- Previous by thread: help on INDEX
- Next by thread: Re: How can I collapse Excel data into categories?
- Index(es):
Relevant Pages
|
