MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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

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

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

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