View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Filtering With Subtotals.

I'd be careful if you're doing this. Data|Filter and Data|Subtotals don't
always work nicely with each other.


pt_lily wrote:

I have a spreadsheet that currently has subtotals in it. I have also applied
auto-filter to the sheet. Whenever I filter for anything, it always pulls
the very last subtotal on the sheet. I cannot seem to figure out why it
keeps pulling this row. Does anyone know how I can keep this from happening?

Thank you!


--

Dave Peterson