excel filtering
 

Gary,
I've tried this, but the number also includes my criteria range, (in my
case, always 4 extra records). How do I eliminate the criteria range from the
count?



"Gary Brown" wrote:

Lower left hand corner of screen will say something like...
'25 of 187 records found' immediately after applying the filter
HTH,
Gary Brown
using Excel XP


"Arthur Kuijper" wrote:

how can I see how many rows meet my filter criteria in excel

I've never seen this include the criteria range (headers????).

When that message shows, it's only counting the rows that are visible after your
filter has been applied.



bronsonbits wrote:

Gary,
I've tried this, but the number also includes my criteria range, (in my
case, always 4 extra records). How do I eliminate the criteria range from the
count?

"Gary Brown" wrote:

Lower left hand corner of screen will say something like...
'25 of 187 records found' immediately after applying the filter
HTH,
Gary Brown
using Excel XP


"Arthur Kuijper" wrote:

how can I see how many rows meet my filter criteria in excel

--

Dave Peterson