excel filtering

G

Gary Brown

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
 
G

Gord Dibben

Gary

Not necessarily.

From Debra Dalgleish......................

Normally, after you have applied an AutoFilter, the Status Bar shows a count
of visible records. Sometimes it just says, "Filter Mode." This can happen
when your list has many formulas. There are articles in the Microsoft
KnowledgeBase that explain:

XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode" Q213886)
XL: AutoFilter Status Bar Message Shows "Filter Mode" (Q189479)


The Status Bar will also show "Filter Mode" if anything is changed in the
list, after a filter has been applied. For example, if you format a cell, or
type a number in one of the records, the 'Filter Mode' message will appear in
the Status Bar.

End Debra.................................

The workaround is as Gary Rowe suggested......The SUBTOTAL Function.

Gord Dibben Excel MVP
 
B

bronsonbits

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?
 
D

Dave Peterson

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.
 
Top