How can the count of filtered records always display?

R

Robert Bushman

When I filter records using the AutoFilter function (Excel 2002), a total of
the number of filtered records usually displays at the bottom on the left end
of the status bar. Sometimes, however, the count does not display at all,
and instead is only the word "Ready." How can I get the count to display
always ?
 
B

Bob Phillips

Debra Dalgleish provided this answer to a similar question

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



--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top