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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks