Excel Filter Mode Record Found in Status Bar

[Guest]

In Excel filter mode, the status bar at the bottom shows either "Filter Mode" or "X of Y Records Found". I cannot consistently duplicate the later, which is very useful.

How do you make the status bar state "X of Y Records Found".

 

[Debra Dalgleish]

When your list has many formulas, the Status Bar may show "Filter Mode"
instead of a count of the visible records. You can use the Subtotal
function to count the visible rows.

The following MSKB article has some information:

XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode"
http://support.microsoft.com/default.aspx?id=213886

And a couple of workarounds:
http://www.contextures.com/xlautofilter02.html#Count

 

[Earl Kiosterud]

Les,

You can roll your own in a cell:

=SUBTOTAL(3,A2:A65536) & " of " & COUNTA(A2:A65536) & " records found."

There must be an entry in every row in column A for this to work properly.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

In Excel filter mode, the status bar at the bottom shows either "Filter

Mode" or "X of Y Records Found". I cannot consistently duplicate the later,
which is very useful.

 

[Guest]

Thank you.

The article below identified exactly what I need to do.


XL2000: Excel AutoFilter Status Bar Message Shows "Filter
Mode"
http://support.microsoft.com/default.aspx?id=213886