items filtered

[roxanne]

I have all of my data filtered.Ex. : I go in and select filter for people by
the name of Smith. At the bottom left corner it should say "4 items out of 52
found". My spreadsheet no longer gives me that information it just says
"filter mode". I never had this problem before, I'm assuming I have
accidently keyed something in wrong.
HELP

 

[Peo Sjoblom]

You can use the SUBTOTAL function like

=SUBTOTAL(3,Full_Range)&" items out of "&COUNTA(Full_Range)&" found"

for an explanation see

http://www.contextures.com/xlautofilter02.html#Count



--


Regards,


Peo Sjoblom

 

[Soundar]

Hi,

Please check the below link, so that you will get some idea.

http://support.microsoft.com/kb/213886

Regards,
Soundar.