Sorting subtotals

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

Pete Provencher

Using Excel 2000:

Is it possible to sort on a subtotaled item? I used Data/Subtotals to
arrange the data how I would like to see it but now Can I sort the list by
the number of items that it grouped on?


Pete Provencher
 
I used xl2002 to try this.

I did a Data|subtotals and added in my totals. But I also included a sum for
the key column. (It added to 0, since all my keys were text.)

but then I selected that whole column and did
Edit|replace
subtotal(9
with
subtotal(3

Now those 0 subtotals (which used to be sums) got changed to counts.

then I use the outlining symbols to the left to just show those subtotals. I
sorted by that column (data|sort) and my detail records had moved with the
sorted subtotal records.

You may want to try it out against a copy of your data--just in case.

You may want to look at Data|Pivottable. It might make your life easier if
you're doing things with summaries/subtotals.
 
Back
Top