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)
