ExcelBanter - Record count in filter mode

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Record count in filter mode (https://www.excelbanter.com/excel-discussion-misc-queries/77849-record-count-filter-mode.html)

jlt

Record count in filter mode

When I filter records in Excel the number of records are not displayed on the
Status Bar. I am expecting results i.e. 5 of 50 records. All I see is
"Filter Mode". How do I correct to display 5 of 50 records??

Dave Peterson

Record count in filter mode

Debra Dalgleish explains it he
http://contextures.com/xlautofilter02.html#Count

and has some work arounds there, too.

jlt wrote:

When I filter records in Excel the number of records are not displayed on the
Status Bar. I am expecting results i.e. 5 of 50 records. All I see is
"Filter Mode". How do I correct to display 5 of 50 records??

--

Dave Peterson

All times are GMT +1. The time now is 02:54 PM.