Counting the no. of entries after applying autofilter

1

1max

I have a column of data in excel, which contains both numbers and chars.
now without any filter on the data I can easily count the no of rows
present (as the row count is mentioned in the right most column)
I want to ask that how can I automatically count the rows when I apply
filter on the data and select a particular entry

I hope that you understand my question, otherwise pls just ask for
clarification :)
 
M

Marcelo

Hi 1max,

to count the rows use subtotal(2,range)

hope this helps
regards from Brazil
Marcelo

"1max" escreveu:
 
Top