Data-Filter and "Number of records" message

[Tim Childs]

Hi

Can someone tell me why when using Data-Filter-Autofilter I only sometimes
get the message in the Status Bar showing that I have filtered 15 out of 25
records. I am using Excel 2000 and other colleagues also report similar
erratic behaviour (in relation to Excel, that is)

Thanks

Tim

 

[Debra Dalgleish]

When your list has many formulas, the Status Bar may show "Filter Mode"
instead of a count of the visible records. You can use the Subtotal
function to count the visible rows.

The following MSKB article has some information:

XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode"
http://support.microsoft.com/default.aspx?scid=kb;en-ca;213886

XL: AutoFilter Status Bar Message Shows "Filter Mode"
http://support.microsoft.com/default.aspx?scid=kb;en-ca;189479

And a couple of workarounds:
http://www.contextures.com/xlautofilter02.html#Count

 

[Tim Childs]

Debra

Many thanks for such a quick and comprehensive answer

The MSKB refers to XL97 but it is still true in XL2000

"The information in this article applies to:
a.. Microsoft Excel 97 for Windows
b.. Microsoft Excel for Windows 95 7.0
c.. Microsoft Excel for Windows 95 7.0a
d.. Microsoft Excel for Windows 5.0
e.. Microsoft Excel for Windows 5.0a
f.. Microsoft Excel for Windows 5.0c
g.. Microsoft Excel for the Macintosh 5.0
h.. Microsoft Excel for the Macintosh 5.0a"
Regards

Tim

 

[Tim Childs]

Hi

Noticed that MS seem to have fixed the problem in XP.

Regards

Tim