View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ramez Ramez is offline
external usenet poster
 
Posts: 3
Default How to obtain the number of filtered records in Autofilter

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.