View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
1max
 
Posts: n/a
Default Counting the no. of entries after applying autofilter


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