filter and count

[rexmann]

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

 

[Frank Kabel]

Hi
=SUBTOTAL(3,A1:a100)

 

[rexmann]

Thanks Frank

worked a treat.

Cheers Rexmann

Hi
=SUBTOTAL(3,A1:a100)