Record count in filter mode

[jlt]

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]

Debra Dalgleish explains it here:
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