Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
Count after filterPosted 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 filterPosted 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 filterPosted by Aladin Akyurek on May 25, 2001 12:38 PM
Put what follows in a row above (or below) the list you filter:
Range must be specified such that it includes the first row of the list and extends to the last row of the list.
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.