Excel Autofilter
What's your filter criteria?
One way to guarantee that your total does not appear is to separate it from
the rest of the table by insert a blank row.
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"Don" wrote:
Hi all,
I suspect there's an easy workaround to this ...
I have activated an Autofilter but notice that when I use the filter my
TOTAL row (for example) is also captured in the filter?
How can I ensure that the autofilter only acts within a defined sub-set of
rows?
Thx,
Don-
|