View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kasiopi
 
Posts: n/a
Default Filters, Subtotal & Intacted Results after the filters' Removal


Hello.

I have a problem:
I have a data list on which I aplly a filter. In order to count the
results of the filter I use the subtotal function. The problem is that
when I remove the filter the results of the subtotal change, and are
abjusted to the new appearence of the data, which is normal, but not
not what I hoped for. I want this result to be intacked, and
independent of the wheather the folters remains or not.

Can anybody help me???

Thanks in advance..


--
kasiopi
------------------------------------------------------------------------
kasiopi's Profile: http://www.excelforum.com/member.php...o&userid=31848
View this thread: http://www.excelforum.com/showthread...hreadid=515704