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
|