Auto Filter and Grouping

[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

 

[Dave Peterson]

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.