ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   count records which meet filter criteria (https://www.excelbanter.com/excel-discussion-misc-queries/52971-count-records-meet-filter-criteria.html)

AKH

count records which meet filter criteria
 
Usually, the number of records that meet the filter criteria on excel show up
in the bottom left hand corner of the spreadsheet but this isn't working.
can anyone shed any light?

Dave Peterson

count records which meet filter criteria
 
Debra Dalgleish explains why and provides some workarounds at:
http://contextures.com/xlautofilter02.html#Count

AKH wrote:

Usually, the number of records that meet the filter criteria on excel show up
in the bottom left hand corner of the spreadsheet but this isn't working.
can anyone shed any light?


--

Dave Peterson


All times are GMT +1. The time now is 07:47 AM.

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