sorting grouped cells

D

D$

Is it possible to sort grouped cells? I have a sheet designed for volleyball
stats where total stats show when all the individual game cells are
collapsed, and I want to sort the total stats rows and have all the grouped
data also be sorted.
 
B

Bernie Deitrick

No - use the data as the source of a pivot table, and then you can
automatically sort the resulting calculated values.


HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Sorting Multiple Tables 1
How to count a coloum if two conditions are met 5
Searching based on text 7
Date Format 2
Index/Match Lookup with a merged col 2
Dealing with the error: unable to filter on excel hc home school 0
Cannot sort a table containing text 5

Top