Sorting after subtotaling
 

Hi,

I have just subtotaled an inventory spreadsheet at work and now have 13,000
lines of data. Now that I have the subtotals by inventory item, I want sort
so that I have all the subtotals together as a group, and all the data that
went into the subtotals separated out. But Excel refuses to do this, even
though I have two columns that I would be able to do this by because the
subtotals have nothing in those two columns and the other lines do have data
in those two columns. I am very frustrated, because going through 13,000
lines of data to delete this information by hand will be extremely
time-consuming!!! Please help!!!

Thank you,
Katherine

Depending on what Subtotals you are doing, you may explore SUMIF, COUNTIF,
and SUMPRODUCT.
The Database Functions may also be an aternative for you.
Check the Help Files for these functions.

You may also try posting an example of exactly what you are trying to
accomplish to this board.

If you haven't done it already you might play with the outline created by
the Subtotals Feature as well.

tj


"Katherine" wrote:

Hi,

I have just subtotaled an inventory spreadsheet at work and now have 13,000
lines of data. Now that I have the subtotals by inventory item, I want sort
so that I have all the subtotals together as a group, and all the data that
went into the subtotals separated out. But Excel refuses to do this, even
though I have two columns that I would be able to do this by because the
subtotals have nothing in those two columns and the other lines do have data
in those two columns. I am very frustrated, because going through 13,000
lines of data to delete this information by hand will be extremely
time-consuming!!! Please help!!!

Thank you,
Katherine