View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I get the filter mode to show the good row count?

Debra Dalgleish explains it and gives some alternatives:
http://contextures.com/xlautofilter02.html#Count

vera wrote:

I filter worksheets extensively, and I always used to have the count appear
on the status bar on the bottom left showing me how many rows met my
criteria. All of a sudden, all it says is 'fitler mode', and i'm going
crazy counting by hand!

Please let me know how to set the page to provide the counts.


--

Dave Peterson