Hi 1max,

to count the rows use subtotal(2,range)

hope this helps
regards from Brazil
Marcelo

"1max" escreveu:


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 :)


--
1max
------------------------------------------------------------------------
1max's Profile: http://www.excelforum.com/member.php...o&userid=35605
View this thread: http://www.excelforum.com/showthread...hreadid=553763