Autofilter count ?

[Jock1970]

I have several spreadsheets which I use with 'autofilter' to view specific records.
Usually when I filter on any column text appears in the bar (immediately above 'start' in the taskbar) saying something like '15 of 279 records found' - i find this very useful.
A new spreadsheet created recently does not do this. When I use 'autofilter' in it some text does flash in the bar but it's so fast you can't read it and it changes to 'Ready'.
Is the record count a feature that can be switched on or off ? If so, how do I do it ?
The count still works in my older spreadsheets, just not the new one.

Cheers,

Jock

 

[gizmo1973]

This is one that annoys me no end as well.
I get around this by selecting (highlighting, ctrl,shift and down) the range that has been filtered and then use the count function on the lower right of the screen (usually set to sum, right click and choose count) once set to count this will give you the ammount of cells filtered on.
If anyone knows the ture answer to the question I'd be interetsted too!!

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts