How to obtain the number of filtered records in Autofilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to switch ON the option of obtaining the total number of filtered records
when using Autofilter in Excel?
In Excel, when using Autofilter option, I can read sometimes in the satus
bar the number of filtered records. Often this information is missing in the
lefthand side of status bar. There is a way to find the info by selecting
"Count" in the right hand side of status bar but this introduce mistakes by
adding title lines.
 
Thanks very much Gord. The answers were there but mostly it explained why I
was not seeing the information (too much formulas and/or changes after
filtering). I will be able to workaround it now.
 

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

Counting Filtered Results Using Autofilter 2
Count the number of AutoFiltered records 6
How can the count of filtered records always display? 1
autofilter count 1
VBA: How can I use a string variable as autofilter criteria? 4
How do I count the number of records autofilter is showing in Exce 3
when autofiltering a spreadsheet need to know number of records 2
How do I get the number of rows that meet an autofilter criterion. 4

Back
Top