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
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