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
 
Top