ExcelBanter - filter and count

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - filter and count (https://www.excelbanter.com/excel-discussion-misc-queries/825-filter-count.html)

rexmann

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

Frank Kabel

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

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

All times are GMT +1. The time now is 01:36 PM.