Hi all

when doing a filter the count function still counts filtered data. I copy
and paste the data into another sheet and do count but this seems clumsy. Is
there a count unfilter function or something

any help appreciated

Rexmann

Hi
=SUBTOTAL(3,A1:a100)

"rexmann" wrote:

Hi all

when doing a filter the count function still counts filtered data. I copy
and paste the data into another sheet and do count but this seems clumsy. Is
there a count unfilter function or something

any help appreciated

Rexmann

Thanks Frank

worked a treat.

Cheers Rexmann

"Frank Kabel" wrote:

Hi
=SUBTOTAL(3,A1:a100)

"rexmann" wrote:

Hi all

when doing a filter the count function still counts filtered data. I copy
and paste the data into another sheet and do count but this seems clumsy. Is
there a count unfilter function or something

any help appreciated

Rexmann