ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I get Auto filter to report number of records filtered? (https://www.excelbanter.com/setting-up-configuration-excel/213945-how-do-i-get-auto-filter-report-number-records-filtered.html)

Walldorc

How do I get Auto filter to report number of records filtered?
 
How do I get Auto filter to report number of records filtered in bottom left
hand corner of screen. I have seen this before but the spread sheet I am
using at the moment just changes from ready to filter mode?

Dave Peterson

How do I get Auto filter to report number of records filtered?
 
Debra Dalgleish explains it and offers a workaround:
http://contextures.com/xlautofilter02.html#Count

Walldorc wrote:

How do I get Auto filter to report number of records filtered in bottom left
hand corner of screen. I have seen this before but the spread sheet I am
using at the moment just changes from ready to filter mode?


--

Dave Peterson


All times are GMT +1. The time now is 01:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com