Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filter and count
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|