Prev: Copying values/formulas from only visable lines when filters are o
Next: Excel Sorting
From: D$ on 16 Mar 2010 13:28
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.
From: "Bernie Deitrick" deitbe on 16 Mar 2010 15:47
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


"D$" <D$@discussions.microsoft.com> wrote in message
news:E97DD9F7-D6C5-44E0-92A4-D4DFCFC62501(a)microsoft.com...
> 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.


 | 
Pages: 1
Prev: Copying values/formulas from only visable lines when filters are o
Next: Excel Sorting