Counting Filtered Results Using Autofilter

J

jj

I frequently use Autofilter to count the number of instances in a column of
data. Usually, when I apply the autofilter to the column heading and execute
a search, the number of results appears in a bar at the lower left hand
corner of the Excel window, similar to "127 of 658 items".

Periodically, this changes to "Ready" and no longer returns the number of
instances of the filtered results.

Any idea why this happens, how can I prevent it, and how do I make it
starting counting again?

Thanks

John
 

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