I used Data|Subtotal to create my groups (not data|group).
And autofilter worked ok on it.
The =subtotal() formulas do get confused by rows hidden by filter or by the
outlining symbols.
When I shared workbooks with others, I would only use one or the other--not
both. It seemed to make life a little easier.
If this doesn't help, you may want to explain what doesn't work when you try it.
Dan Foxley wrote:
Is there a way for Auto Filter of columns to work when I'm using Groups as
well? If not are there similar options?
Thanks,
Dan Foxley
--
Dave Peterson
|