items filtered
 

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

items filtered
 

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


"roxanne" wrote in message
...
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

items filtered
 

Hi,

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

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

Regards,
Soundar.

"roxanne" wrote:

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