Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

Count after filter

Posted by Tom on May 25, 2001 11:47 AM

How can i count the number of rows after running an advanced filter on a column? I have a HUGE standard report, but then i run several filters on columns. I need to get a count of the number of rows each time i run a filter. How can this be done? thanx in advance!!! tom

Re: Count after filter

Posted by Paul Godley on May 25, 2001 12:37 PM

Tom, use the formula "=Subtotal(2,datarange)", where datarange is the column to be evaluated.
The subtotal function will work on the visible cells in a filtered list. Paul

Re: Count after filter

Posted by Aladin Akyurek on May 25, 2001 12:38 PM

Put what follows in a row above (or below) the list you filter:

=SUBTOTAL(3,range)

Range must be specified such that it includes the first row of the list and extends to the last row of the list.

Aladin

Make: 2 --> 3 if data consist of numbers... (NT)

Posted by Aladin Akyurek on May 25, 2001 12:41 PM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.