How to count rows in a user-defined AutoFilter or AdvancedFilter is active?

F

Frank Krogh

How do I count rows in a user-defined Auto-filter on the following columns?

ID Age Sex
123 54 male
321 76 female
432 33 male

Can I apply the same method on a predefined filter criteria (using the
AdvancedFilter function)?

Thanks for any suggestions.


Frank Krogh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFilter Row Count 4
How To Count Rows Displayed After Applying AutoFilter 2
How do i analyse visible rows only in excel? 8
Suggested new functionalities for Filters, Pivots and other issues 0
http://netscan.research.microsoft.com/Static/reportcard.asp?timespan=y&searchdate=6/13/2004&searchfo 0
Outlook crashes with Outlook connector 2002 0
Outlook connector crashes outlook 0

Top