Prev: Calculating new date by entering number of additional workdays
Next: How do I reference the cell which returned a lookup value?
From: jj on 1 Apr 2010 18:58
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
From: Dave Peterson on 1 Apr 2010 19:17
You sure you're seeing Ready?

Debra Dalgleish explains it here and offers a work-around:
http://contextures.com/xlautofilter02.html#Count

jj wrote:
>
> 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

--

Dave Peterson
From: Gord Dibben on 1 Apr 2010 19:18
Explanation and workarounds at Debra Dalgleish's site.

http://www.contextures.on.ca/xlautofilter02.html#Count

Another alternative.......after filtering, select the visible cells in a
column and right-click on Status Bar and "Count"


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 15:58:01 -0700, jj <jj(a)discussions.microsoft.com> wrote:

>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

 | 
Pages: 1
Prev: Calculating new date by entering number of additional workdays
Next: How do I reference the cell which returned a lookup value?