In Excel, How do I get AutoFilter to provide# of records found?

D

DougD

I use Autofilter command a lot and many times it shows the total number of
filtered records from the total anount of records in the lower-left hand part
of screen. For instance - it will sat "33 of 90 records found". Inevitably,
this stops working and this area just sates "Filter Mode" without the
previous info. I have been unable to find any rhyme or reason what I did to
stop the valubale info of how many records were found.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to show the figure of the filtered records ? 1
How can I always get subtotals (4 of 12 records)when I filter a sh 1
How to obtain the number of filtered records in Autofilter 2
How to "Capture" Records Found Number During AutoFilter 2
how do I display filtered records found 1
How can I ensure #records in a selected set always shows in Excel 1
How do I get the filter results to show up in the status bar? 2
AutoFilter - How to determine number of records found 3

Top