How to obtain the number of filtered records in Autofilter

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.
 
G

Guest

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
How can the count of filtered records always display? 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
AutoFiltler Displays number of number records in Status Bar 1
Copy Paste filtered column ok in 2003 not in 2007 3
How do I count rows in a filtered list when using AutoFilter? 5
Count the number of AutoFiltered records 6

Top